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.IGS_AD_IMP_006 dependencies on IGS_AD_HZ_EMP_DTL

Line 647: FROM hz_employment_history pe, igs_ad_interface_all ii, igs_ad_hz_emp_dtl ahed, hz_parties hz

643: WHERE mi.interface_run_id = l_interface_run_id
644: AND mi.match_ind IS NULL
645: AND mi.status = '2'
646: AND EXISTS ( SELECT '1'
647: FROM hz_employment_history pe, igs_ad_interface_all ii, igs_ad_hz_emp_dtl ahed, hz_parties hz
648: WHERE ii.interface_run_id = l_interface_run_id
649: AND ii.interface_id = mi.interface_id
650: AND ii.person_id = pe.party_id
651: AND pe.employment_history_id = ahed.employment_history_id (+)

Line 730: FROM hz_employment_history heh, igs_ad_hz_emp_dtl ahed, hz_parties hz

726: heh.object_version_number,
727: heh.employed_by_party_id,
728: heh.reason_for_leaving reason_for_leaving,
729: null occupational_title
730: FROM hz_employment_history heh, igs_ad_hz_emp_dtl ahed, hz_parties hz
731: WHERE heh.party_id = cp_person_id
732: AND heh.employment_history_id = ahed.employment_history_id (+)
733: AND heh.employed_by_party_id = hz.party_id (+)
734: AND ( NVL(UPPER(heh.employed_by_name_company),'!*!') = NVL(UPPER(cp_employer),'!*!')