APPS.JL_JLBRRINV_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 297: HR_ORGANIZATION_UNITS ORG

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
301: AND SU.SITE_USE_ID = C_SHIP_TO_SITE_USE_ID

Line 332: HR_ORGANIZATION_UNITS ORG

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
336: WHEN NO_DATA_FOUND THEN