SMS_Depura todas las tablas de un embarque

declare @ship nvarchar(11)
select @ship = '8799000036' 
 
 ---Depura Import
delete   thd_sms_gateway.import.rcpartialpo where Merchantshipmentnumber = @ship
delete   thd_sms_gateway.import.shipmentheader where ShipmentNumber = @ship
delete  thd_sms_gateway.Import.HMPalletScan where MerchantShipNumber = @Ship
delete   thd_sms_gateway.Import.ShipmentReceive where MerchantShipmentNumber = @ship
delete   thd_sms_gateway.Import.ShipmentTransfer where MerchantShipmentNumber = @ship
delete   thd_sms_gateway.Import.Dlxferdet where Merchanttransferno in (select MerchantTransferNo from thd_sms_gateway.import.DlxFerHdr where ShipmentNumber = @ship)
delete   thd_sms_gateway.Import.DlxFerHdr where Merchanttransferno in (select MerchantTransferNo from thd_sms_gateway.import.ShipmentTransfer where MerchantShipmentNumber = @ship) 
delete   thd_sms_gateway.Import.ComplementaryShipmentHeader   WHERE MerchantShipmentNumber = @ship

 ---Depura Local
delete  rcpartialpo where  shipmentnumber = @ship
delete   shipmentheader where ShipmentNumber = @ship
delete   Palletdetail where palletID IN (Select  PalletID from PalletHeader where ShipmentNumber = @Ship) 
delete   PalletHeader where ShipmentNumber = @Ship
delete   ShipmentReceive where ShipmentNumber = @ship
delete   ShipmentTransfer where ShipmentNumber = @ship
delete   Dlxferdet where TransferNo in (select TransferNo from DlxFerHdr where ShipmentNumber = @ship)
delete   DlxFerHdr where TransferNo in (select TransferNo from ShipmentTransfer where ShipmentNumber = @ship)