356:
357: --Start of 3604377
358: l_pos_ei_grade_data per_position_extra_info%rowtype;
359:
360: CURSOR cur_grd(p_grade_id per_grades.grade_id%TYPE) IS
361: SELECT gdf.segment1 pay_plan
362: ,gdf.segment2 grade_or_level
363: FROM per_grade_definitions gdf
364: ,per_grades grd
360: CURSOR cur_grd(p_grade_id per_grades.grade_id%TYPE) IS
361: SELECT gdf.segment1 pay_plan
362: ,gdf.segment2 grade_or_level
363: FROM per_grade_definitions gdf
364: ,per_grades grd
365: WHERE grd.grade_id = p_grade_id
366: AND grd.grade_definition_id = gdf.grade_definition_id;
367: --End of 3604377
368: