APPS.CSP_PARTS_ORDER dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1645: hr_all_organization_units org

1641: nvl(sub.location_id, org.location_id)
1642: into l_header_rec.ship_to_location_id
1643: from
1644: MTL_SECONDARY_INVENTORIES sub,
1645: hr_all_organization_units org
1646: where org.organization_id = l_header_rec.dest_organization_id
1647: and org.organization_id = sub.organization_id(+)
1648: and sub.secondary_inventory_name(+) = l_header_rec.dest_subinventory;
1649: end if;