282: NVL(HRL.GLOBAL_ATTRIBUTE1, 'DEFAULT')
283: INTO l_location_id,
284: l_org_class
285: FROM HR_LOCATIONS_ALL HRL,
286: HR_ORGANIZATION_UNITS ORG
287: WHERE ORG.LOCATION_ID = HRL.LOCATION_ID
288: AND ORG.ORGANIZATION_ID = NVL(p_ship_from_org_id,
289: NVL(p_invoice_to_org_id,
290: OE_PROFILE.VALUE('SO_ORGANIZATION_ID')));