DBA Data[Home] [Help]

APPS.GHR_PC_BASIC_PAY dependencies on HR_POSITIONS_F

Line 2744: SELECT ORGANIZATION_ID FROM HR_POSITIONS_F

2740:
2741: CURSOR cur_get_pos_org(p_pos_id per_positions.position_id%TYPE,
2742: p_eff_Date ghr_pa_requests.effective_date%TYPE)
2743: IS
2744: SELECT ORGANIZATION_ID FROM HR_POSITIONS_F
2745: WHERE position_id=p_pos_id
2746: AND p_eff_date between effective_start_Date and effective_end_date;
2747:
2748: BEGIN