APPS.WSH_REGIONS_SEARCH_PKG dependencies on HZ_LOCATIONS

Line 1705: FROM hz_locations l, fnd_territories_tl t

1701: ORDER BY country, state, city, postal_code_from;
1702:
1703: CURSOR get_loc_info (l_start_date DATE, l_end_date DATE) IS
1704: SELECT t.territory_short_name, t.territory_code, nvl(l.state, l.province) state, l.city, l.postal_code
1705: FROM hz_locations l, fnd_territories_tl t
1706: WHERE t.territory_code = l.country and
1707: t.language = userenv('LANG') and
1708: l.last_update_date >= nvl(l_start_date, l.last_update_date) and
1709: l.last_update_date < nvl(l_end_date, l.last_update_date+1);

Line 2220: FROM HZ_LOCATIONS

2216: END IF;
2217:
2218: EXECUTE IMMEDIATE 'SELECT MIN(LOCATION_ID),MAX(LOCATION_ID)
2219: FROM ( SELECT location_id, NTILE(:num_instances) OVER (ORDER BY location_id) worker
2220: FROM HZ_LOCATIONS
2221: WHERE last_update_date >= nvl(:start_date, last_update_date)
2222: AND last_update_date < nvl(:end_date, last_update_date+1)
2223: )
2224: GROUP BY WORKER'