[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
2948: RETURN VARCHAR2 IS
2949: --
2950: -- Since Position Extra Info now has history use the history packages written to get
2951: -- the user_table_id
2952: l_pos_ei_data per_position_extra_info%ROWTYPE;
2953: --
2954: --
2955: BEGIN
2956: ghr_history_fetch.fetch_positionei(
3296: l_dummy VARCHAR2(30);
3297: l_assignment_id per_assignments_f.assignment_id%type;
3298: l_from_position_id ghr_pa_requests.from_position_id%type;
3299: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3300: l_pos_ei_grade_data per_position_extra_info%rowtype;
3301:
3302: 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
3303: SELECT paf.assignment_id, paf.position_id
3304: FROM per_assignments_f paf
3945: l_fwfa_pay_plan_changed BOOLEAN;
3946: ------ Bug#5741977 end
3947:
3948: -- 7046241
3949: l_pos_ei_valid_grade per_position_extra_info%ROWTYPE;
3950: -- 7046241
3951:
3952: PROCEDURE set_cpt_ppt_prd(p_leo_flag IN BOOLEAN
3953: ,p_rg_flag IN BOOLEAN