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.AMS_DMEXTRACT_PVT dependencies on HZ_EMPLOYMENT_HISTORY

Line 301: FROM hz_employment_history e

297: AND d.party_id = x.party_id
298: AND SYSDATE BETWEEN d.effective_start_date AND NVL(d.effective_end_date,SYSDATE))
299: UNION ALL
300: (SELECT e.party_id
301: FROM hz_employment_history e
302: WHERE e.last_update_date > x.last_update_date
303: AND e.party_id = x.party_id
304: AND e.status = 'A')
305: UNION ALL

Line 692: hz_employment_history heh,

688: ams_dm_drv_stg_gt drv, -- nysotos - Sep 15, 2003 - Global Temp Table
689: hz_person_profiles hpp,
690: hz_organization_profiles hop,
691: hz_org_contacts hoc,
692: hz_employment_history heh,
693: hz_relationships hpr,
694: hz_parties hzp
695: WHERE
696: drv.party_id = hzp.party_id

Line 796: hz_employment_history heh,

792: FROM
793: -- ams_dm_drv_stg drv,
794: ams_dm_drv_stg_gt drv, -- nysotos - Sep 15, 2003 - Global Temp Table
795: hz_person_profiles hpp,
796: hz_employment_history heh,
797: hz_parties hzp
798: WHERE
799: drv.party_id = hzp.party_id
800: AND hzp.status = 'A'