APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_LOCATIONS

Line 2539: FROM wsh_locations

2535: -- TODO
2536: -- check against definition of wsh_hr_locations_v
2537: CURSOR get_location_data(c_location_id IN NUMBER) IS
2538: SELECT country, nvl(state, province), city, postal_code
2539: FROM wsh_locations
2540: WHERE wsh_location_id = c_location_id;
2541:
2542:
2543: j NUMBER := 0;