APPS.HR_SUIT_MATCH_UTIL_SS dependencies on HR_ALL_POSITIONS_F
Line 137: FROM hr_all_positions_f hpf
133: CURSOR csr_position_dets(p_position_id in number) IS
134: SELECT hpf.position_id,
135: hpf.organization_id,
136: hpf.job_id 137: FROM hr_all_positions_f hpf 138: WHERE TRUNC(sysdate) BETWEEN hpf.effective_start_date
139: AND hpf.effective_end_date
140: AND TRUNC(sysdate) BETWEEN hpf.date_effective
141: AND NVL(hpf.date_end, TRUNC(sysdate))