APPS.CSE_ASSET_CREATION_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2566: FROM hr_all_organization_units

2562:
2563: IF l_location_id IS NULL THEN
2564: SELECT location_id
2565: INTO l_location_id
2566: FROM hr_all_organization_units
2567: WHERE organization_id = l_organization_id;
2568: END IF;
2569:
2570: ELSIF csi_txn_rec.transaction_type_id IN (132, 133, 105) OR