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 1702: ,p_position_id IN hr_all_positions_f.position_id%TYPE

1698:
1699: END get_total_salary;
1700:
1701: PROCEDURE main_pay_calc (p_person_id IN per_people_f.person_id%TYPE
1702: ,p_position_id IN hr_all_positions_f.position_id%TYPE
1703: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
1704: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1705: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
1706: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE

Line 1757: l_position_id hr_all_positions_f.position_id%TYPE;

1753: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;
1754: --
1755: l_effective_date DATE;
1756: --
1757: l_position_id hr_all_positions_f.position_id%TYPE;
1758: l_noa_family_code ghr_families.noa_family_code%TYPE;
1759: l_noa_code ghr_nature_of_actions.code%TYPE;
1760: l_second_noa_code ghr_nature_of_actions.code%TYPE;
1761: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;