APPS.HZ_PURGE_GEN dependencies on AMS_AGENDAS_B

Line 4678: --AMS_AGENDAS_B;COORDINATOR_ID

4674: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4675: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_PARTY_MARKET_SEGMENTS xx
4676: );
4677: end if;
4678: --AMS_AGENDAS_B;COORDINATOR_ID
4679: appid:=530;
4680: if(regid_proc = true) then
4681: 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
4682:

Line 4683: temp.party_id in (select /*+ parallel(xx)*/ xx.COORDINATOR_ID from AMS_AGENDAS_B xx

4679: appid:=530;
4680: if(regid_proc = true) then
4681: 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
4682:
4683: temp.party_id in (select /*+ parallel(xx)*/ xx.COORDINATOR_ID from AMS_AGENDAS_B xx
4684: );
4685: else
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

Line 4687: temp.party_id in (select /*+ parallel(xx)*/ xx.COORDINATOR_ID from AMS_AGENDAS_B xx

4683: temp.party_id in (select /*+ parallel(xx)*/ xx.COORDINATOR_ID from AMS_AGENDAS_B xx
4684: );
4685: else
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;