1015: CURSOR cur_grd IS
1016: SELECT gdf.segment1 pay_plan
1017: ,gdf.segment2 grade_or_level
1018: FROM per_grade_definitions gdf
1019: ,per_grades grd
1020: WHERE grd.grade_id = p_grade_id
1021: AND grd.grade_definition_id = gdf.grade_definition_id;
1022: --
1023: CURSOR cur_org (p_org_id number) IS
2349: l_valid_grade varchar2(150);
2350: l_grade_id varchar2(150);
2351: CURSOR cur_grd IS
2352: SELECT grd.name grade_name
2353: FROM per_grades grd
2354: WHERE grd.grade_id = TO_NUMBER(l_grade_id);
2355:
2356:
2357: BEGIN