APPS.HZ_PURGE_GEN dependencies on XLE_REG_FUNCTIONS

Line 5172: --XLE_REG_FUNCTIONS;AUTHORITY_ID

5168: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5169: temp.party_id in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx
5170: );
5171: end if;
5172: --XLE_REG_FUNCTIONS;AUTHORITY_ID
5173: appid:=204;
5174: if(regid_proc = true) then
5175: insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and
5176:

Line 5177: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx

5173: appid:=204;
5174: if(regid_proc = true) then
5175: insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and
5176:
5177: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx
5178: );
5179: else
5180: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5181: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx

Line 5181: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx

5177: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx
5178: );
5179: else
5180: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5181: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx
5182: );
5183: end if;
5184: --XLE_REGISTRATIONS;ISSUING_AUTHORITY_SITE_ID
5185: appid:=204;

Line 5206: --XLE_REG_FUNCTIONS;AUTHORITY_SITE_ID

5202: in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS
5203: yy
5204: ));
5205: end if;
5206: --XLE_REG_FUNCTIONS;AUTHORITY_SITE_ID
5207: appid:=204;
5208: if(regid_proc = true) then
5209: insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and
5210:

Line 5215: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS

5211: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5212: xx
5213: where (nvl(STATUS, 'A') in ('A','I'))
5214: and xx.PARTY_SITE_ID
5215: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS
5216: yy
5217: ));
5218: else
5219: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5224: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS

5220: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5221: xx
5222: where (nvl(STATUS, 'A') in ('A','I'))
5223: and xx.PARTY_SITE_ID
5224: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS
5225: yy
5226: ));
5227: end if;
5228: --IBW_PAGE_VIEWS;PARTY_ID