APPS.HZ_PURGE_GEN dependencies on XLE_REGISTRATIONS

Line 5380: --XLE_REGISTRATIONS;ISSUING_AUTHORITY_ID

5376: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS
5377: yy
5378: ));
5379: end if;
5380: --XLE_REGISTRATIONS;ISSUING_AUTHORITY_ID
5381: appid:=204;
5382: if(regid_proc = true) then
5383: 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
5384:

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

5381: appid:=204;
5382: if(regid_proc = true) then
5383: 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
5384:
5385: temp.party_id in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx
5386: );
5387: else
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

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

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

Line 5404: --XLE_REGISTRATIONS;ISSUING_AUTHORITY_SITE_ID

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;
5406: if(regid_proc = true) then
5407: 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
5408:

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

5409: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5410: xx
5411: where (nvl(STATUS, 'A') in ('A','I'))
5412: and xx.PARTY_SITE_ID
5413: in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS
5414: yy
5415: ));
5416: else
5417: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

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