APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_REGION_LOCATIONS

Line 2477: wsh_region_locations loc

2473: wr.city_code,
2474: decode(loc.parent_region_flag,'Y','N','N','Y')
2475: FROM wsh_regions wr,
2476: wsh_regions_tl wrt,
2477: wsh_region_locations loc
2478: WHERE wr.region_id = l_region_id AND
2479: loc.location_id = l_location_id AND
2480: wr.region_id = loc.region_id AND
2481: wrt.region_id = wr.region_id AND

Line 2511: FROM wsh_region_locations wrl, wsh_regions_tl wrt,

2507: rt.language = nvl(l_lang_code,rt.language);
2508:
2509: CURSOR Check_Location_Exists(c_location_id IN NUMBER,c_lang_code IN VARCHAR2) IS
2510: SELECT 'exists'
2511: FROM wsh_region_locations wrl, wsh_regions_tl wrt,
2512: wsh_regions wr
2513: WHERE wrl.region_id is not null
2514: AND wrl.location_id = c_location_id
2515: AND wrl.region_id = wrt.region_id

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

2614: IF l_exists IS NOT NULL THEN
2615: /*
2616: SELECT wrl.region_id
2617: BULK COLLECT INTO l_rgid_tab
2618: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
2619: WHERE wrl.location_id = p_location_id
2620: AND wrl.region_id is not null
2621: AND wrl.region_id = wrt.region_id
2622: AND wrt.language = nvl(p_lang_code,wrt.language)

Line 2985: -- using table WSH_REGION_LOCATIONS

2981: --
2982: -- Procedure: Get_All_RegionId_Matches
2983: --
2984: -- Purpose : The API derives Region id for an input location,
2985: -- using table WSH_REGION_LOCATIONS
2986: -- Cache is used for storing and retriving location region mappings.
2987: -- when p_use_cache is FALSE
2988:
2989: PROCEDURE Get_All_RegionId_Matches(

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

2995:
2996:
2997: CURSOR c_get_all_region_id(l_location_id IN NUMBER, l_lang_code IN VARCHAR2) IS
2998: SELECT wrl.region_id
2999: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
3000: WHERE wrl.location_id = l_location_id
3001: AND wrl.region_id is not null
3002: AND wrl.region_id = wrt.region_id
3003: AND wrt.language = nvl(l_lang_code,wrt.language)

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

3257: CURSOR c_get_all_regions_loc(c_location_id IN NUMBER, c_lang_code IN VARCHAR2) IS
3258: SELECT wrl.region_id,
3259: wr.region_type,
3260: wr.deconsol_location_id
3261: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
3262: WHERE wrl.location_id = c_location_id
3263: AND wrl.region_id IS NOT NULL
3264: AND wrl.region_id = wrt.region_id
3265: AND wrt.language = nvl('US',wrt.language)