APPS.HZ_PURGE_GEN dependencies on ECX_TP_HEADERS

Line 2811: exists (select 'Y' from ECX_TP_HEADERS xx where xx.PARTY_ID = temp.party_id

2807: if(regid_proc = true) then
2808: insert into hz_application_trans_gt(app_id,party_id) select 174, temp.party_id from hz_purge_gt temp where
2809:
2810:
2811: exists (select 'Y' from ECX_TP_HEADERS xx where xx.PARTY_ID = temp.party_id
2812: );
2813: else
2814: delete from hz_purge_gt temp where
2815:

Line 2817: exists (select 'Y' from ECX_TP_HEADERS xx where xx.PARTY_ID = temp.party_id

2813: else
2814: delete from hz_purge_gt temp where
2815:
2816:
2817: exists (select 'Y' from ECX_TP_HEADERS xx where xx.PARTY_ID = temp.party_id
2818: );
2819: end if;
2820:
2821:

Line 5138: --ECX_TP_HEADERS;PARTY_SITE_ID

5134: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B
5135: yy
5136: ));
5137: end if;
5138: --ECX_TP_HEADERS;PARTY_SITE_ID
5139: appid:=174;
5140: if(regid_proc = true) then
5141: insert into hz_application_trans_gt(app_id,party_id) select 174, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 174 and appl.party_id=temp.party_id) and
5142:

Line 5147: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS

5143: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5144: xx
5145: where (nvl(STATUS, 'A') in ('A','I'))
5146: and xx.PARTY_SITE_ID
5147: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS
5148: yy
5149: ));
5150: else
5151: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5156: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS

5152: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5153: xx
5154: where (nvl(STATUS, 'A') in ('A','I'))
5155: and xx.PARTY_SITE_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