DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on HR_ORGANIZATION_UNITS

Line 286: HR_ORGANIZATION_UNITS ORG

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')));