APPS.HZ_PURGE_GEN dependencies on XLE_REG_FUNCTIONS

Line 5392: --XLE_REG_FUNCTIONS;AUTHORITY_ID

5388: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5389: temp.party_id in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx
5390: );
5391: end if;
5392: --XLE_REG_FUNCTIONS;AUTHORITY_ID
5393: appid:=204;
5394: if(regid_proc = true) then
5395: 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
5396:

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

5393: appid:=204;
5394: if(regid_proc = true) then
5395: 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
5396:
5397: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx
5398: );
5399: else
5400: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5401: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx

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

5397: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx
5398: );
5399: else
5400: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5401: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx
5402: );
5403: end if;
5404: --XLE_REGISTRATIONS;ISSUING_AUTHORITY_SITE_ID
5405: appid:=204;

Line 5426: --XLE_REG_FUNCTIONS;AUTHORITY_SITE_ID

5422: in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS
5423: yy
5424: ));
5425: end if;
5426: --XLE_REG_FUNCTIONS;AUTHORITY_SITE_ID
5427: appid:=204;
5428: if(regid_proc = true) then
5429: 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
5430:

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

5431: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5432: xx
5433: where (nvl(STATUS, 'A') in ('A','I'))
5434: and xx.PARTY_SITE_ID
5435: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS
5436: yy
5437: ));
5438: else
5439: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

5440: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5441: xx
5442: where (nvl(STATUS, 'A') in ('A','I'))
5443: and xx.PARTY_SITE_ID
5444: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS
5445: yy
5446: ));
5447: end if;
5448: --IBW_PAGE_VIEWS;PARTY_ID