APPS.MST_GEOCODING dependencies on WSH_LOCATIONS

Line 66: from WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND

62: BEGIN
63:
64: select FND.UPGRADE_TZ_ID, FND.TIMEZONE_CODE
65: into p_timezone_id, p_timezone_code
66: from WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND
67: where WSH.TIMEZONE_CODE = FND.TIMEZONE_CODE AND
68: WSH.WSH_LOCATION_ID = p_location_id;
69:
70: EXCEPTION

Line 158: from WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND

154:
155: BEGIN
156: select FND.UPGRADE_TZ_ID, FND.TIMEZONE_CODE
157: into p_timezone_id, p_timezone_code
158: from WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND
159: where WSH.TIMEZONE_CODE = FND.TIMEZONE_CODE AND
160: WSH.WSH_LOCATION_ID = p_location_id;
161:
162: EXCEPTION

Line 218: -- If no information exists in WSH_LOCATIONS or HZ_TIMEZONES, we will

214: return x_timezone_short_code;
215: END IF;
216:
217: -- Initialize timezone_code to server timezone code
218: -- If no information exists in WSH_LOCATIONS or HZ_TIMEZONES, we will
219: -- return the server timezone code
220:
221: p_timezone_id := to_number( FND_PROFILE.VALUE('SERVER_TIMEZONE_ID') );
222:

Line 256: from WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND

252:
253: BEGIN
254: select FND.UPGRADE_TZ_ID, FND.TIMEZONE_CODE
255: into p_timezone_id, p_timezone_code
256: from WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND
257: where WSH.TIMEZONE_CODE = FND.TIMEZONE_CODE AND
258: WSH.WSH_LOCATION_ID = p_location_id;
259:
260: EXCEPTION

Line 308: -- If no information exists in WSH_LOCATIONS or HZ_TIMEZONES, we will

304: return x_timezone_short_code;
305: END IF;
306:
307: -- Initialize timezone_code to server timezone code
308: -- If no information exists in WSH_LOCATIONS or HZ_TIMEZONES, we will
309: -- return the server timezone code
310:
311: p_timezone_id := to_number( FND_PROFILE.VALUE('SERVER_TIMEZONE_ID') );
312: