373: FUNCTION get_grade
374: (p_grade_id NUMBER) return VARCHAR2
375: --
376: AS 377: l_grade_name per_grades.name%type; 378: --
379: begin
380: --
381: hr_utility.trace('Entered Get_Grade');
Line 387: FROM per_grades_vl
383: begin
384: hr_utility.set_location('hr_reports.get_grade',5);
385: SELECT name
386: INTO l_grade_name 387: FROM per_grades_vl 388: WHERE grade_id = p_grade_id;
389: --
390: exception when NO_DATA_FOUND then null;
391: end;