APPS.JE_JEPLPSSR_XMLP_PKG dependencies on HR_LOCATIONS

Line 795: HR_LOCATIONS LOC,

791: SELECT
792: ORG.NAME
793: INTO L_ORG_NAME
794: FROM
795: HR_LOCATIONS LOC,
796: HR_ALL_ORGANIZATION_UNITS ORG
797: WHERE ORG.ORGANIZATION_ID = CF_ORG_NAMEFORMULA.ORGANIZATION_ID
798: AND LOC.LOCATION_ID = ORG.LOCATION_ID;
799: RETURN (L_ORG_NAME);