APPS.JG_JGZZSRCR_XMLP_PKG dependencies on HR_OPERATING_UNITS

Line 796: OPERATING_UNIT_NAME HR_OPERATING_UNITS.NAME%TYPE;

792:
793: FUNCTION CF_ORGANIZATIONFORMULA(ORG_ID IN NUMBER) RETURN VARCHAR2 IS
794: BEGIN
795: DECLARE
796: OPERATING_UNIT_NAME HR_OPERATING_UNITS.NAME%TYPE;
797: BEGIN
798: SELECT
799: HR.NAME
800: INTO OPERATING_UNIT_NAME

Line 802: HR_OPERATING_UNITS HR

798: SELECT
799: HR.NAME
800: INTO OPERATING_UNIT_NAME
801: FROM
802: HR_OPERATING_UNITS HR
803: WHERE HR.ORGANIZATION_ID = ORG_ID;
804: RETURN (OPERATING_UNIT_NAME);
805: EXCEPTION
806: WHEN NO_DATA_FOUND THEN