[Home] [Help]
25: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type
26: ,p_effective_date IN date)
27: RETURN BOOLEAN IS
28: --
29: l_pos_ei_data per_position_extra_info%ROWTYPE;
30: l_range_or_match pay_user_tables.range_or_match%type;
31: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
32: l_user_table_id pay_user_tables.user_table_id%type;
33: l_proc varchar2(30) := 'get_open_pay_range';
110: RETURN NUMBER IS
111: --
112: -- Since Position Extra Info now has history use the history packages written to get
113: -- the user_table_id
114: l_pos_ei_data per_position_extra_info%ROWTYPE;
115: --
116: --
117: BEGIN
118: ghr_history_fetch.fetch_positionei(
877: ,p_effective_date IN DATE)
878: RETURN BOOLEAN IS
879:
880: l_pay_table varchar2(4);
881: l_pos_ei_grp2_data per_position_extra_info%rowtype;
882:
883: BEGIN
884: /***** New LEO Locality Pay calculation.
885: -- bug 709492 for retained grade PRD's check the retained user table id
3162: RETURN VARCHAR2 IS
3163: --
3164: -- Since Position Extra Info now has history use the history packages written to get
3165: -- the user_table_id
3166: l_pos_ei_data per_position_extra_info%ROWTYPE;
3167: --
3168: --
3169: BEGIN
3170: ghr_history_fetch.fetch_positionei(
3510: l_dummy VARCHAR2(30);
3511: l_assignment_id per_assignments_f.assignment_id%type;
3512: l_from_position_id ghr_pa_requests.from_position_id%type;
3513: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3514: l_pos_ei_grade_data per_position_extra_info%rowtype;
3515:
3516: CURSOR get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type, c_effective_date IN ghr_pa_requests.effective_date%type) IS
3517: SELECT paf.assignment_id, paf.position_id
3518: FROM per_assignments_f paf
4163: l_fwfa_pay_plan_changed BOOLEAN;
4164: ------ Bug#5741977 end
4165:
4166: -- 7046241
4167: l_pos_ei_valid_grade per_position_extra_info%ROWTYPE;
4168: -- 7046241
4169:
4170: --Bug# 9258929
4171: l_from_position_id ghr_pa_requests.from_position_id%type;