APPS.GHR_VALIDATE_CHECK dependencies on GHR_FAMILIES

Line 72: l_noa_family_code ghr_families.noa_family_code%type;

68: l_stad_amount number;
69: l_ap_amount number;
70: l_auo_amount number;
71: l_exists boolean;
72: l_noa_family_code ghr_families.noa_family_code%type;
73: l_to_agency_code per_people_extra_info.pei_information8%type;
74: l_to_supervisor_diff ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type ;
75: l_award_salary ghr_pa_requests.from_basic_pay%type ; -- Bug 3376761
76:

Line 212: ghr_families fam

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'
216: and l_effective_date between NVL(nfa.start_date_active,l_effective_date)