eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PURGE_GEN dependencies on WSH_CARRIERS

Line 240: exists (select 'Y' from WSH_CARRIERS xx where xx.CARRIER_ID = temp.party_id

236: if(regid_proc = true) then
237: insert into hz_application_trans_gt(app_id,party_id) select 665, temp.party_id from hz_purge_gt temp where
238:
239:
240: exists (select 'Y' from WSH_CARRIERS xx where xx.CARRIER_ID = temp.party_id
241: )
242:
243: or exists (select 'Y' from HZ_PARTY_SITES
244: xx where xx.PARTY_ID = temp.party_id

Line 254: exists (select 'Y' from WSH_CARRIERS xx where xx.CARRIER_ID = temp.party_id

250: else
251: delete from hz_purge_gt temp where
252:
253:
254: exists (select 'Y' from WSH_CARRIERS xx where xx.CARRIER_ID = temp.party_id
255: )
256:
257: or exists (select 'Y' from HZ_PARTY_SITES
258: xx where xx.PARTY_ID = temp.party_id