DBA Data[Home] [Help]

APPS.WSH_REGIONS_SEARCH_PKG dependencies on FND_TERRITORIES_TL

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);