APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_GRADES

Line 2714: FUNCTION get_grade_name (p_grade_id IN per_grades.grade_id%TYPE)

2710: end if;
2711: return l_corps_name;
2712: END;
2713:
2714: FUNCTION get_grade_name (p_grade_id IN per_grades.grade_id%TYPE)
2715: RETURN VARCHAR2 IS
2716: l_grade_name varchar2(100);
2717: BEGIN
2718: if p_grade_id is not null then

Line 2719: select name into l_grade_name from per_grades_vl where

2715: RETURN VARCHAR2 IS
2716: l_grade_name varchar2(100);
2717: BEGIN
2718: if p_grade_id is not null then
2719: select name into l_grade_name from per_grades_vl where
2720: grade_id = p_grade_id;
2721: end if;
2722: return l_grade_name;
2723: END;