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