DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTIL_SS dependencies on HR_ALL_POSITIONS_F

Line 144: FROM hr_all_positions_f hpf

140: CURSOR csr_position_dets(p_position_id in number) IS
141: SELECT hpf.position_id,
142: hpf.organization_id,
143: hpf.job_id
144: FROM hr_all_positions_f hpf
145: WHERE TRUNC(sysdate) BETWEEN hpf.effective_start_date
146: AND hpf.effective_end_date
147: AND TRUNC(sysdate) BETWEEN hpf.date_effective
148: AND NVL(hpf.date_end, TRUNC(sysdate))