APPS.JL_JLBRRINV_XMLP_PKG dependencies on HR_LOCATIONS

Line 296: HR_LOCATIONS HRL,

292: HZ_LOCATIONS LOCN,
293: HZ_PARTY_SITES PST,
294: HZ_CUST_SITE_USES SU,
295: HZ_GEOGRAPHIES GEO,
296: HR_LOCATIONS HRL,
297: HR_ORGANIZATION_UNITS ORG
298: WHERE ORG.ORGANIZATION_ID = H_OPERATION_UNIT
299: AND HRL.LOCATION_ID = ORG.LOCATION_ID
300: AND LOC.SHIP_FROM_CODE = HRL.REGION_2

Line 331: HR_LOCATIONS HRL,

327: SELECT
328: HRL.GLOBAL_ATTRIBUTE5
329: INTO X_BRAND
330: FROM
331: HR_LOCATIONS HRL,
332: HR_ORGANIZATION_UNITS ORG
333: WHERE ORG.ORGANIZATION_ID = H_OPERATION_UNIT
334: AND HRL.LOCATION_ID = ORG.LOCATION_ID;
335: EXCEPTION