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.GHR_VALIDATE_CHECK dependencies on GHR_NOA_FAMILIES

Line 211: from ghr_noa_families nfa,

207: -- Bug # 1145963
208: -- Bug#3941541 Added effective date condition.
209: Cursor c_noa_family_code(l_effective_date DATE) IS
210: Select fam.noa_family_code
211: from ghr_noa_families nfa,
212: ghr_families fam
213: where nfa.nature_of_action_id = p_pa_request_rec.first_noa_id
214: and nfa.noa_family_code = fam.noa_family_code
215: and fam.update_hr_flag = 'Y'

Line 507: FROM ghr_noa_families noa

503: AND ee.effective_start_date > l_effective_date;
504:
505: CURSOR cur_noa_id(l_noa_id NUMBER,l_noa_fam_code VARCHAR2, l_eff_date DATE) is
506: SELECT 1
507: FROM ghr_noa_families noa
508: WHERE noa.nature_of_action_id = l_noa_id
509: AND noa.noa_family_code = l_noa_fam_code
510: AND l_eff_date BETWEEN nvl(noa.start_date_active,l_eff_date)
511: AND nvl(noa.end_date_active,l_eff_date)