APPS.HZ_PURGE_GEN dependencies on AMS_TCOP_PRVW_FTG_DTLS

Line 4726: --AMS_TCOP_PRVW_FTG_DTLS;PARTY_ID

4722: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4723: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_CONTACTS xx
4724: );
4725: end if;
4726: --AMS_TCOP_PRVW_FTG_DTLS;PARTY_ID
4727: appid:=530;
4728: if(regid_proc = true) then
4729: insert into hz_application_trans_gt(app_id,party_id) select 530, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 530 and appl.party_id=temp.party_id) and
4730:

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

4727: appid:=530;
4728: if(regid_proc = true) then
4729: insert into hz_application_trans_gt(app_id,party_id) select 530, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 530 and appl.party_id=temp.party_id) and
4730:
4731: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_FTG_DTLS xx
4732: );
4733: else
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

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

4731: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_FTG_DTLS xx
4732: );
4733: else
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;