APPS.JA_JAIN23C1_XMLP_PKG dependencies on HR_LOCATIONS

Line 515: HR_LOCATIONS HRL,

511: ,10) || ' ' || SUBSTR(HRL.COUNTRY
512: ,1
513: ,10)
514: FROM
515: HR_LOCATIONS HRL,
516: RCV_TRANSACTIONS RCVT,
517: RCV_SHIPMENT_HEADERS RCVSH,
518: JAI_OM_WSH_LINES_ALL JSPL,
519: HR_ALL_ORGANIZATION_UNITS HRU

Line 546: HR_LOCATIONS HRL

542: ,1
543: ,10)
544: FROM
545: HR_ALL_ORGANIZATION_UNITS HRU,
546: HR_LOCATIONS HRL
547: WHERE HRU.ORGANIZATION_ID = ABS(VENDOR_ID)
548: AND HRL.LOCATION_ID = ABS(VENDOR_SITE_ID)
549: AND HRU.LOCATION_ID = HRL.LOCATION_ID;
550: V_VENDOR_DTLS VARCHAR2(200);