APPS.HZ_PURGE_GEN dependencies on XLE_REGISTRATIONS

Line 5160: --XLE_REGISTRATIONS;ISSUING_AUTHORITY_ID

5156: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS
5157: yy
5158: ));
5159: end if;
5160: --XLE_REGISTRATIONS;ISSUING_AUTHORITY_ID
5161: appid:=204;
5162: if(regid_proc = true) then
5163: 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
5164:

Line 5165: temp.party_id in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx

5161: appid:=204;
5162: if(regid_proc = true) then
5163: 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
5164:
5165: temp.party_id in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx
5166: );
5167: else
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

Line 5169: temp.party_id in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx

5165: temp.party_id in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx
5166: );
5167: else
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;

Line 5184: --XLE_REGISTRATIONS;ISSUING_AUTHORITY_SITE_ID

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;
5186: if(regid_proc = true) then
5187: 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
5188:

Line 5193: in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS

5189: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5190: xx
5191: where (nvl(STATUS, 'A') in ('A','I'))
5192: and xx.PARTY_SITE_ID
5193: in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS
5194: yy
5195: ));
5196: else
5197: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5202: in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS

5198: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5199: xx
5200: where (nvl(STATUS, 'A') in ('A','I'))
5201: and xx.PARTY_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