APPS.GHR_PAY_CALC dependencies on HR_ALL_POSITIONS_F

Line 22: FUNCTION get_open_pay_range (p_position_id IN hr_all_positions_f.position_id%TYPE

18: END set_form_item_name;
19:
20: --
21:
22: FUNCTION get_open_pay_range (p_position_id IN hr_all_positions_f.position_id%TYPE
23: ,p_person_id IN per_all_people_f.person_id%type
24: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
25: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type
26: ,p_effective_date IN date)

Line 108: FUNCTION get_user_table_id (p_position_id IN hr_all_positions_f.position_id%TYPE

104:
105: END get_open_pay_range;
106:
107:
108: FUNCTION get_user_table_id (p_position_id IN hr_all_positions_f.position_id%TYPE
109: ,p_effective_date IN date)
110: RETURN NUMBER IS
111: --
112: -- Since Position Extra Info now has history use the history packages written to get

Line 220: ,p_position_id IN hr_all_positions_f.position_id%TYPE

216: --Bug#5132113 added new parameter p_open_range_out_basic_pay
217:
218: FUNCTION populate_in_rec_structure
219: (p_person_id IN per_people_f.person_id%TYPE
220: ,p_position_id IN hr_all_positions_f.position_id%TYPE
221: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
222: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
223: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
224: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE

Line 292: FROM hr_all_positions_f pos

288: PROCEDURE validate_in_data(p_pay_calc_data IN ghr_pay_calc.pay_calc_in_rec_type) IS
289: --
290: CURSOR c_chk_pos IS
291: SELECT 1
292: FROM hr_all_positions_f pos
293: WHERE p_pay_calc_data.position_id = pos.position_id
294: AND p_pay_calc_data.effective_date BETWEEN pos.effective_start_date
295: and pos.effective_end_date;
296: l_ret_val BOOLEAN := FALSE;

Line 1648: ,p_position_id IN hr_all_positions_f.position_id%TYPE

1644:
1645: END get_total_salary;
1646:
1647: PROCEDURE main_pay_calc (p_person_id IN per_people_f.person_id%TYPE
1648: ,p_position_id IN hr_all_positions_f.position_id%TYPE
1649: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
1650: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1651: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
1652: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE

Line 1703: l_position_id hr_all_positions_f.position_id%TYPE;

1699: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;
1700: --
1701: l_effective_date DATE;
1702: --
1703: l_position_id hr_all_positions_f.position_id%TYPE;
1704: l_noa_family_code ghr_families.noa_family_code%TYPE;
1705: l_noa_code ghr_nature_of_actions.code%TYPE;
1706: l_second_noa_code ghr_nature_of_actions.code%TYPE;
1707: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;