APPS.HZ_PURGE_GEN dependencies on AMS_TCOP_CONTACTS

Line 4702: --AMS_TCOP_CONTACTS;PARTY_ID

4698: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4699: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx
4700: );
4701: end if;
4702: --AMS_TCOP_CONTACTS;PARTY_ID
4703: appid:=530;
4704: if(regid_proc = true) then
4705: 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
4706:

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

4703: appid:=530;
4704: if(regid_proc = true) then
4705: 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
4706:
4707: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CONTACTS xx
4708: );
4709: else
4710: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4711: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CONTACTS xx

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

4707: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CONTACTS xx
4708: );
4709: else
4710: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4711: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CONTACTS xx
4712: );
4713: end if;
4714: --AMS_TCOP_PRVW_CONTACTS;PARTY_ID
4715: appid:=530;