APPS.HZ_PURGE_GEN dependencies on AMS_PARTY_MARKET_SEGMENTS

Line 4932: --AMS_PARTY_MARKET_SEGMENTS;PARTY_ID

4928: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4929: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx
4930: where (SITE_CATEGORY_TYPE = 'AFFILIATES'));
4931: end if;
4932: --AMS_PARTY_MARKET_SEGMENTS;PARTY_ID
4933: appid:=530;
4934: if(regid_proc = true) then
4935: 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
4936:

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

4933: appid:=530;
4934: if(regid_proc = true) then
4935: 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
4936:
4937: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_PARTY_MARKET_SEGMENTS xx
4938: );
4939: else
4940: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4941: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_PARTY_MARKET_SEGMENTS xx

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

4937: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_PARTY_MARKET_SEGMENTS xx
4938: );
4939: else
4940: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4941: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_PARTY_MARKET_SEGMENTS xx
4942: );
4943: end if;
4944: --AMS_AGENDAS_B;COORDINATOR_ID
4945: appid:=530;