dbo.QER_ZITShopMemberDelete

1       create   procedure QER_ZITShopMemberDelete (@SlotNumber int) as begin declare @DebugLevel char(1) = 'W' declare @PWOsToMove QBM_YParameterList
2     BEGIN TRY insert into @PWOsToMove (Parameter1, Parameter2, Parameter3, HasContentFull) select pwo.UID_PersonWantsOrg, null , x.GenProcID, 1 from (
3 select UID_Parameter as uid_person, UID_SubParameter as uid_OrgSH, GenProcID from QBMDBQueueCurrent p with (readpast) where p.SlotNumber = @SlotNumber
4 ) as x join PersonWantsOrg pwo on x.uid_person = pwo.UID_PersonOrdered and x.uid_OrgSH = pwo.UID_OrgParentOfParent where not exists (select top 1 1 from
5 BaseTree cu join personinBaseTree pio on cu.uid_parentorg = x.uid_OrgSH and cu.itshopInfo = 'CU' and pio.uid_org = cu.uid_org and pio.uid_person = x.uid_person
6 and pio.XOrigin > 0 ) exec QER_PITShopOrderMove_bulk @PWOsToMove END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT
7 END CATCH end 
8