APPS.HZ_PURGE_GEN dependencies on AMS_TCOP_CHANNEL_SUMMARY

Line 4956: --AMS_TCOP_CHANNEL_SUMMARY;PARTY_ID

4952: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4953: temp.party_id in (select /*+ parallel(xx)*/ xx.COORDINATOR_ID from AMS_AGENDAS_B xx
4954: );
4955: end if;
4956: --AMS_TCOP_CHANNEL_SUMMARY;PARTY_ID
4957: appid:=530;
4958: if(regid_proc = true) then
4959: 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
4960:

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

4957: appid:=530;
4958: if(regid_proc = true) then
4959: 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
4960:
4961: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx
4962: );
4963: else
4964: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4965: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx

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

4961: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx
4962: );
4963: else
4964: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4965: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx
4966: );
4967: end if;
4968: --AMS_TCOP_CONTACTS;PARTY_ID
4969: appid:=530;