APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2502: FROM hr_all_organization_units ou,

2498: AND location_source_code = 'HR';
2499:
2500: CURSOR check_company(c_loc_id IN NUMBER) IS
2501: SELECT ou.organization_id
2502: FROM hr_all_organization_units ou,
2503: mtl_parameters mp
2504: WHERE mp.organization_id = ou.organization_id
2505: AND ou.location_id = c_loc_id;
2506: