87: --
88: CURSOR cur_grd(l_grade_id NUMBER) IS
89: SELECT gdf.segment1 pay_plan
90: ,gdf.segment2 grade_or_level
91: FROM per_grade_definitions gdf
92: ,per_grades grd
93: WHERE grd.grade_id = l_grade_id
94: AND grd.grade_definition_id = gdf.grade_definition_id;
95:
118:
119: l_his_match BOOLEAN := FALSE;
120: l_pos_valid BOOLEAN := FALSE;
121: l_pos_ei_data per_position_extra_info%rowtype;
122: l_pay_plan per_grade_definitions.segment1%type;
123: l_grade_or_level per_grade_definitions.segment2%type;
124: l_posei_id per_position_extra_info.position_extra_info_id%type;
125: l_grd_id per_position_extra_info.poei_information5%type;
126: l_hist_id ghr_pa_history.pa_history_id%type;
119: l_his_match BOOLEAN := FALSE;
120: l_pos_valid BOOLEAN := FALSE;
121: l_pos_ei_data per_position_extra_info%rowtype;
122: l_pay_plan per_grade_definitions.segment1%type;
123: l_grade_or_level per_grade_definitions.segment2%type;
124: l_posei_id per_position_extra_info.position_extra_info_id%type;
125: l_grd_id per_position_extra_info.poei_information5%type;
126: l_hist_id ghr_pa_history.pa_history_id%type;
127: l_his_eff_date ghr_pa_requests.effective_date%type;