APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PQH_CORPS_DEFINITIONS

Line 2696: select name into l_corps_name from pqh_corps_definitions

2692: l_corps_id := to_number(c_corps.segment7);
2693: end loop;
2694:
2695: if l_corps_id is not null then
2696: select name into l_corps_name from pqh_corps_definitions
2697: where corps_definition_id = l_corps_id;
2698: end if;
2699:
2700: return l_corps_name;

Line 2703: FUNCTION get_corps_name (p_corps_id IN pqh_corps_definitions.corps_definition_id%TYPE)

2699:
2700: return l_corps_name;
2701: END;
2702:
2703: FUNCTION get_corps_name (p_corps_id IN pqh_corps_definitions.corps_definition_id%TYPE)
2704: RETURN VARCHAR2 IS
2705: l_corps_name varchar2(100);
2706: BEGIN
2707: if p_corps_id is not null then

Line 2708: select name into l_corps_name from pqh_corps_definitions

2704: RETURN VARCHAR2 IS
2705: l_corps_name varchar2(100);
2706: BEGIN
2707: if p_corps_id is not null then
2708: select name into l_corps_name from pqh_corps_definitions
2709: where corps_definition_id = p_corps_id;
2710: end if;
2711: return l_corps_name;
2712: END;