APPS.HZ_PURGE_GEN dependencies on AMS_TCOP_CHANNEL_SUMMARY

Line 4690: --AMS_TCOP_CHANNEL_SUMMARY;PARTY_ID

4686: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4687: temp.party_id in (select /*+ parallel(xx)*/ xx.COORDINATOR_ID from AMS_AGENDAS_B xx
4688: );
4689: end if;
4690: --AMS_TCOP_CHANNEL_SUMMARY;PARTY_ID
4691: appid:=530;
4692: if(regid_proc = true) then
4693: 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
4694:

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

4691: appid:=530;
4692: if(regid_proc = true) then
4693: 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
4694:
4695: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx
4696: );
4697: else
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

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

4695: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx
4696: );
4697: else
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;