APPS.HZ_PURGE_GEN dependencies on CSC_CUST_PLANS

Line 4738: --CSC_CUST_PLANS;PARTY_ID

4734: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4735: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_FTG_DTLS xx
4736: );
4737: end if;
4738: --CSC_CUST_PLANS;PARTY_ID
4739: appid:=511;
4740: if(regid_proc = true) then
4741: insert into hz_application_trans_gt(app_id,party_id) select 511, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 511 and appl.party_id=temp.party_id) and
4742:

Line 4743: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx

4739: appid:=511;
4740: if(regid_proc = true) then
4741: insert into hz_application_trans_gt(app_id,party_id) select 511, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 511 and appl.party_id=temp.party_id) and
4742:
4743: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx
4744: );
4745: else
4746: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4747: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx

Line 4747: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx

4743: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx
4744: );
4745: else
4746: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4747: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx
4748: );
4749: end if;
4750: --ISC_DR_REPAIR_ORDERS_F;CUSTOMER_ID
4751: appid:=454;