APPS.GHR_VALIDATE_CHECK dependencies on HR_ALL_POSITIONS_F

Line 110: select pps.status from hr_all_positions_f pps -- Venkat - Position DT

106: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
107:
108: ------- Retrieve Position Status --
109: cursor c_get_psn_status(p_position_id number) is
110: select pps.status from hr_all_positions_f pps -- Venkat - Position DT
111: where pps.position_id = p_position_id
112: and p_pa_request_rec.effective_date between pps.effective_start_date
113: and pps.effective_end_date;
114: -------