APPS.CSP_EXCESS_PARTS_PVT dependencies on HR_LOCATIONS_ALL

Line 2451: hr_locations_all hrloc

2447: hrloc.country as country
2448: from
2449: MTL_SECONDARY_INVENTORIES sub,
2450: hr_all_organization_units org,
2451: hr_locations_all hrloc
2452: where org.organization_id = v_org_id
2453: and org.organization_id = sub.organization_id(+)
2454: and sub.secondary_inventory_name(+) = v_subinv
2455: and nvl(sub.location_id, org.location_id) = hrloc.location_id;