APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_LOCATIONS

Line 2269: FROM wsh_locations

2265: -- TODO
2266: -- check against definition of wsh_hr_locations_v
2267: CURSOR get_location_data(c_location_id IN NUMBER) IS
2268: SELECT country, nvl(state, province), city, postal_code
2269: FROM wsh_locations
2270: WHERE wsh_location_id = c_location_id;
2271:
2272:
2273: j NUMBER := 0;