DBA Data[Home] [Help]

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on HR_ORGANIZATION_UNITS

Line 3930: HR_ORGANIZATION_UNITS ORG

3926: NVL(HRL.GLOBAL_ATTRIBUTE1, 'DEFAULT')
3927: INTO l_location_id,
3928: l_org_class
3929: FROM HR_LOCATIONS_ALL HRL ,
3930: HR_ORGANIZATION_UNITS ORG
3931: WHERE ORG.LOCATION_ID = HRL.LOCATION_ID
3932: --++ nipatel verify this join condition
3933: --++ Condition changed for Bug#7438620
3934: AND ORG.ORGANIZATION_ID = NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_org_id(p_index),