DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on HR_ORGANIZATION_UNITS

Line 291: HR_ORGANIZATION_UNITS ORG

287: NVL(HRL.GLOBAL_ATTRIBUTE1, 'DEFAULT')
288: INTO l_location_id,
289: l_org_class
290: FROM HR_LOCATIONS_ALL HRL,
291: HR_ORGANIZATION_UNITS ORG
292: WHERE ORG.LOCATION_ID = HRL.LOCATION_ID
293: AND ORG.ORGANIZATION_ID = NVL(p_ship_from_org_id,
294: NVL(p_invoice_to_org_id,
295: OE_PROFILE.VALUE('SO_ORGANIZATION_ID')));