954:
955: /* Cursor to retrieve Grade of Employee */
956: CURSOR csr_grade(p_grade_id NUMBER) IS
957: SELECT pg.name 958: FROM per_grades_tl pg 959: WHERE pg.grade_id = p_grade_id;
960:
961: /* Cursor to retrieve Position of Employee */
962: CURSOR csr_position(p_position_id NUMBER) IS