APPS.MST_GEOCODING dependencies on FND_TIMEZONES_VL

Line 36: from FND_TIMEZONES_VL

32: BEGIN
33:
34: select TIMEZONE_CODE
35: into l_server_timezone_code
36: from FND_TIMEZONES_VL
37: where UPGRADE_TZ_ID = l_server_timezone_id;
38:
39: EXCEPTION
40: WHEN NO_DATA_FOUND THEN

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 130: from FND_TIMEZONES_VL

126: BEGIN
127:
128: select TIMEZONE_CODE
129: into l_server_timezone_code
130: from FND_TIMEZONES_VL
131: where UPGRADE_TZ_ID = l_server_timezone_id;
132:
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN

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 227: from FND_TIMEZONES_VL

223: BEGIN
224:
225: select TIMEZONE_CODE
226: into p_timezone_code
227: from FND_TIMEZONES_VL
228: where UPGRADE_TZ_ID = p_timezone_id;
229:
230: EXCEPTION
231: WHEN NO_DATA_FOUND THEN

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 317: from FND_TIMEZONES_VL

313: BEGIN
314:
315: select TIMEZONE_CODE
316: into p_timezone_code
317: from FND_TIMEZONES_VL
318: where UPGRADE_TZ_ID = p_timezone_id;
319:
320: EXCEPTION
321: WHEN NO_DATA_FOUND THEN