APPS.FTE_LANE_SEARCH dependencies on WSH_LOCATIONS

Line 45: SELECT postal_code FROM wsh_locations

41: l_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
42: l_parent_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
43:
44: CURSOR get_postal_code(p_loc_id NUMBER) IS
45: SELECT postal_code FROM wsh_locations
46: WHERE wsh_location_id = p_loc_id;
47:
48: --
49: l_debug_on BOOLEAN;

Line 214: -- if location id was passed in, obtain zip from wsh_locations API

210: l_parent_regions(l_parent_regions.count +1) := l_region_and_type;
211: END LOOP;
212: END IF;
213:
214: -- if location id was passed in, obtain zip from wsh_locations API
215: IF (p_loc_id is not null AND p_zip is null) THEN
216: OPEN get_postal_code(p_loc_id);
217: FETCH get_postal_code INTO p_zip;
218: CLOSE get_postal_code;