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: -------

Line 367: FROM hr_all_positions_f hap

363: --End Bug# 9898968
364: --Begin Bug# 11781477
365: CURSOR c_get_pos_avl_status (p_position_id number,g_effective_date DATE) IS
366: SELECT HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status
367: FROM hr_all_positions_f hap
368: WHERE g_effective_date BETWEEN hap.effective_start_date
369: AND hap.effective_end_date
370: AND hap.position_id=p_position_id;
371: --End Bug# 11781477