APPS.HZ_PURGE_GEN dependencies on ECX_TP_HEADERS

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

2900: if(regid_proc = true) then
2901: insert into hz_application_trans_gt(app_id,party_id) select 174, temp.party_id from hz_purge_gt temp where
2902:
2903:
2904: exists (select 'Y' from ECX_TP_HEADERS xx where xx.PARTY_ID = temp.party_id
2905: );
2906: else
2907: delete from hz_purge_gt temp where
2908:

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

2906: else
2907: delete from hz_purge_gt temp where
2908:
2909:
2910: exists (select 'Y' from ECX_TP_HEADERS xx where xx.PARTY_ID = temp.party_id
2911: );
2912: end if;
2913:
2914:

Line 5358: --ECX_TP_HEADERS;PARTY_SITE_ID

5354: in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B
5355: yy
5356: ));
5357: end if;
5358: --ECX_TP_HEADERS;PARTY_SITE_ID
5359: appid:=174;
5360: if(regid_proc = true) then
5361: 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
5362:

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

5363: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5364: xx
5365: where (nvl(STATUS, 'A') in ('A','I'))
5366: and xx.PARTY_SITE_ID
5367: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS
5368: yy
5369: ));
5370: else
5371: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

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