APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_REGIONS_TL

Line 364: ' from WSH_REGIONS_INTERFACE R, WSH_REGIONS_TL_INTERFACE TL';

360: ''N'' ';
361:
362: IF (p_interface_flag = 'Y') THEN
363: sql_string := sql_string ||
364: ' from WSH_REGIONS_INTERFACE R, WSH_REGIONS_TL_INTERFACE TL';
365: ELSE
366: sql_string := sql_string ||
367: ' from WSH_REGIONS R, WSH_REGIONS_TL TL';
368: END IF;

Line 367: ' from WSH_REGIONS R, WSH_REGIONS_TL TL';

363: sql_string := sql_string ||
364: ' from WSH_REGIONS_INTERFACE R, WSH_REGIONS_TL_INTERFACE TL';
365: ELSE
366: sql_string := sql_string ||
367: ' from WSH_REGIONS R, WSH_REGIONS_TL TL';
368: END IF;
369:
370: -- sql_string := sql_string ||
371: -- ' where R.REGION_ID = TL.REGION_ID and ROWNUM < 2 ';

Line 891: ', WSH_REGIONS_TL_INTERFACE TL ';

887:
888: IF (p_interface_flag = 'Y') THEN
889:
890: sql_string := sql_string ||
891: ', WSH_REGIONS_TL_INTERFACE TL ';
892:
893: ELSE
894:
895: sql_string := sql_string ||

Line 896: ', WSH_REGIONS_TL TL ';

892:
893: ELSE
894:
895: sql_string := sql_string ||
896: ', WSH_REGIONS_TL TL ';
897:
898: END IF;
899:
900: END IF;

Line 1429: FROM wsh_regions_interface r, wsh_regions_tl_interface t

1425: SELECT nvl(country, country_code) country,
1426: nvl(state,state_code) state,
1427: nvl(city,city_code) city,
1428: postal_code_from
1429: FROM wsh_regions_interface r, wsh_regions_tl_interface t
1430: WHERE r.region_id = t.region_id and r.creation_date >= l_processing_date
1431: ORDER BY country, state, city, postal_code_from;
1432:
1433: CURSOR get_loc_info (l_start_date DATE, l_end_date DATE) IS

Line 2206: wsh_regions_tl wrt,

2202: wr.state_code,
2203: wr.city_code,
2204: decode(loc.parent_region_flag,'Y','N','N','Y')
2205: FROM wsh_regions wr,
2206: wsh_regions_tl wrt,
2207: wsh_region_locations loc
2208: WHERE wr.region_id = l_region_id AND
2209: loc.location_id = l_location_id AND
2210: wr.region_id = loc.region_id AND

Line 2231: wsh_regions_tl rt,

2227: null,
2228: null,
2229: 'N'
2230: FROM wsh_regions r,
2231: wsh_regions_tl rt,
2232: wsh_zone_regions z
2233: WHERE r.region_id = z.parent_region_id AND
2234: z.region_id = l_region_id AND
2235: r.region_type = 10 AND

Line 2241: FROM wsh_region_locations wrl, wsh_regions_tl wrt,

2237: rt.language = nvl(l_lang_code,rt.language);
2238:
2239: CURSOR Check_Location_Exists(c_location_id IN NUMBER,c_lang_code IN VARCHAR2) IS
2240: SELECT 'exists'
2241: FROM wsh_region_locations wrl, wsh_regions_tl wrt,
2242: wsh_regions wr
2243: WHERE wrl.region_id is not null
2244: AND wrl.location_id = c_location_id
2245: AND wrl.region_id = wrt.region_id

Line 2347: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr

2343: IF l_exists IS NOT NULL THEN
2344: /*
2345: SELECT wrl.region_id
2346: BULK COLLECT INTO l_rgid_tab
2347: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
2348: WHERE wrl.location_id = p_location_id
2349: AND wrl.region_id is not null
2350: AND wrl.region_id = wrt.region_id
2351: AND wrt.language = nvl(p_lang_code,wrt.language)

Line 2728: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr

2724:
2725:
2726: CURSOR c_get_all_region_id(l_location_id IN NUMBER, l_lang_code IN VARCHAR2) IS
2727: SELECT wrl.region_id
2728: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
2729: WHERE wrl.location_id = l_location_id
2730: AND wrl.region_id is not null
2731: AND wrl.region_id = wrt.region_id
2732: AND wrt.language = nvl(l_lang_code,wrt.language)

Line 2990: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr

2986: CURSOR c_get_all_regions_loc(c_location_id IN NUMBER, c_lang_code IN VARCHAR2) IS
2987: SELECT wrl.region_id,
2988: wr.region_type,
2989: wr.deconsol_location_id
2990: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
2991: WHERE wrl.location_id = c_location_id
2992: AND wrl.region_id IS NOT NULL
2993: AND wrl.region_id = wrt.region_id
2994: AND wrt.language = nvl('US',wrt.language)