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 OZF_CLAIMS_ALL

Line 404: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.BROKER_ID = temp.party_id

400:
401: exists (select 'Y' from OZF_CUST_TRD_PRFLS_ALL xx where xx.PARTY_ID = temp.party_id
402: )
403:
404: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.BROKER_ID = temp.party_id
405: )
406:
407: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID = temp.party_id
408: )

Line 407: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID = temp.party_id

403:
404: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.BROKER_ID = temp.party_id
405: )
406:
407: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID = temp.party_id
408: )
409:
410: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.BUDGET_SOURCE_ID = temp.party_id
411: and (BUDGET_SOURCE_TYPE='PTNR'))

Line 437: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.BROKER_ID = temp.party_id

433:
434: exists (select 'Y' from OZF_CUST_TRD_PRFLS_ALL xx where xx.PARTY_ID = temp.party_id
435: )
436:
437: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.BROKER_ID = temp.party_id
438: )
439:
440: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID = temp.party_id
441: )

Line 440: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID = temp.party_id

436:
437: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.BROKER_ID = temp.party_id
438: )
439:
440: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID = temp.party_id
441: )
442:
443: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.BUDGET_SOURCE_ID = temp.party_id
444: and (BUDGET_SOURCE_TYPE='PTNR'))