APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_REGION_LOCATIONS

Line 2207: wsh_region_locations loc

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
2211: wrt.region_id = wr.region_id 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 2714: -- using table WSH_REGION_LOCATIONS

2710: --
2711: -- Procedure: Get_All_RegionId_Matches
2712: --
2713: -- Purpose : The API derives Region id for an input location,
2714: -- using table WSH_REGION_LOCATIONS
2715: -- Cache is used for storing and retriving location region mappings.
2716: -- when p_use_cache is FALSE
2717:
2718: PROCEDURE Get_All_RegionId_Matches(

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)