APPS.MRP_MRPRPROP_XMLP_PKG dependencies on HR_LOCATIONS

Line 78: HR_LOCATIONS HR

74: ,0)
75: INTO P_CUSTOMER_ID
76: FROM
77: PO_LOCATION_ASSOCIATIONS_ALL PO,
78: HR_LOCATIONS HR
79: WHERE HR.LOCATION_ID = P_DEFAULT_DELIVERY_TO
80: AND HR.LOCATION_ID = po.location_id (+)
81: AND NVL(PO.ORG_ID
82: ,-11) = NVL(P_PO_ORG_ID

Line 551: LOCATION_NAME HR_LOCATIONS.LOCATION_CODE%TYPE;

547:
548: FUNCTION C_DEFAULT_DEL_PFORMULA RETURN VARCHAR2 IS
549: BEGIN
550: DECLARE
551: LOCATION_NAME HR_LOCATIONS.LOCATION_CODE%TYPE;
552: BEGIN
553: IF (P_DEFAULT_DELIVERY_TO IS NOT NULL) THEN
554: SELECT
555: LOCATION_CODE

Line 558: HR_LOCATIONS

554: SELECT
555: LOCATION_CODE
556: INTO LOCATION_NAME
557: FROM
558: HR_LOCATIONS
559: WHERE LOCATION_ID = P_DEFAULT_DELIVERY_TO;
560: RETURN (LOCATION_NAME);
561: ELSE
562: RETURN (' ');