APPS.HZ_PURGE_GEN dependencies on AMS_IBA_PL_SITES_B

Line 4920: --AMS_IBA_PL_SITES_B;SITE_CATEGORY_OBJECT_ID

4916: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from PO_VENDOR_SITES_ALL
4917: yy
4918: ));
4919: end if;
4920: --AMS_IBA_PL_SITES_B;SITE_CATEGORY_OBJECT_ID
4921: appid:=530;
4922: if(regid_proc = true) then
4923: 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
4924:

Line 4925: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx

4921: appid:=530;
4922: if(regid_proc = true) then
4923: 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
4924:
4925: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx
4926: where (SITE_CATEGORY_TYPE = 'AFFILIATES'));
4927: else
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

Line 4929: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx

4925: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx
4926: where (SITE_CATEGORY_TYPE = 'AFFILIATES'));
4927: else
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;