APPS.CSE_ASSET_CREATION_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
Line 2248: FROM hr_all_organization_units
2244:
2245: IF l_location_id IS NULL THEN
2246: SELECT location_id
2247: INTO l_location_id 2248: FROM hr_all_organization_units 2249: WHERE organization_id = l_organization_id;
2250: END IF;
2251:
2252: ELSIF csi_txn_rec.transaction_type_id IN (132, 133, 105) THEN