APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2518: FROM hr_all_organization_units ou,

2514: AND location_source_code = 'HR';
2515:
2516: CURSOR check_company(c_loc_id IN NUMBER) IS
2517: SELECT ou.organization_id
2518: FROM hr_all_organization_units ou,
2519: mtl_parameters mp
2520: WHERE mp.organization_id = ou.organization_id
2521: AND ou.location_id = c_loc_id;
2522: