APPS.WSH_REGIONS_SEARCH_PKG dependencies on HZ_LOCATIONS

Line 1435: FROM hz_locations l, fnd_territories_tl t

1431: ORDER BY country, state, city, postal_code_from;
1432:
1433: CURSOR get_loc_info (l_start_date DATE, l_end_date DATE) IS
1434: SELECT t.territory_short_name, t.territory_code, nvl(l.state, l.province) state, l.city, l.postal_code
1435: FROM hz_locations l, fnd_territories_tl t
1436: WHERE t.territory_code = l.country and
1437: t.language = userenv('LANG') and
1438: l.last_update_date >= nvl(l_start_date, l.last_update_date) and
1439: l.last_update_date < nvl(l_end_date, l.last_update_date+1);

Line 1950: FROM HZ_LOCATIONS

1946: END IF;
1947:
1948: EXECUTE IMMEDIATE 'SELECT MIN(LOCATION_ID),MAX(LOCATION_ID)
1949: FROM ( SELECT location_id, NTILE(:num_instances) OVER (ORDER BY location_id) worker
1950: FROM HZ_LOCATIONS
1951: WHERE last_update_date >= nvl(:start_date, last_update_date)
1952: AND last_update_date < nvl(:end_date, last_update_date+1)
1953: )
1954: GROUP BY WORKER'