APPS.HZ_PURGE_GEN dependencies on AMS_IBA_PL_SITES_B

Line 4654: --AMS_IBA_PL_SITES_B;SITE_CATEGORY_OBJECT_ID

4650: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4651: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT xx
4652: );
4653: end if;
4654: --AMS_IBA_PL_SITES_B;SITE_CATEGORY_OBJECT_ID
4655: appid:=530;
4656: if(regid_proc = true) then
4657: 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
4658:

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

4655: appid:=530;
4656: if(regid_proc = true) then
4657: 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
4658:
4659: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx
4660: where (SITE_CATEGORY_TYPE = 'AFFILIATES'));
4661: else
4662: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4663: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx

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

4659: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx
4660: where (SITE_CATEGORY_TYPE = 'AFFILIATES'));
4661: else
4662: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4663: temp.party_id in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx
4664: where (SITE_CATEGORY_TYPE = 'AFFILIATES'));
4665: end if;
4666: --AMS_PARTY_MARKET_SEGMENTS;PARTY_ID
4667: appid:=530;