APPS.MST_GEOCODING SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

     select TIMEZONE_CODE
     into   l_server_timezone_code
     from   FND_TIMEZONES_VL
     where  UPGRADE_TZ_ID = l_server_timezone_id;

Line: 64

     select FND.UPGRADE_TZ_ID, FND.TIMEZONE_CODE
     into   p_timezone_id, p_timezone_code
     from   WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND
     where  WSH.TIMEZONE_CODE = FND.TIMEZONE_CODE AND
            WSH.WSH_LOCATION_ID = p_location_id;

Line: 128

     select TIMEZONE_CODE
     into   l_server_timezone_code
     from   FND_TIMEZONES_VL
     where  UPGRADE_TZ_ID = l_server_timezone_id;

Line: 156

     select FND.UPGRADE_TZ_ID, FND.TIMEZONE_CODE
     into   p_timezone_id, p_timezone_code
     from   WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND
     where  WSH.TIMEZONE_CODE = FND.TIMEZONE_CODE AND
            WSH.WSH_LOCATION_ID = p_location_id;

Line: 225

     select TIMEZONE_CODE
     into   p_timezone_code
     from   FND_TIMEZONES_VL
     where  UPGRADE_TZ_ID = p_timezone_id;

Line: 254

     select FND.UPGRADE_TZ_ID, FND.TIMEZONE_CODE
     into   p_timezone_id, p_timezone_code
     from   WSH_LOCATIONS WSH, FND_TIMEZONES_VL FND
     where  WSH.TIMEZONE_CODE = FND.TIMEZONE_CODE AND
            WSH.WSH_LOCATION_ID = p_location_id;

Line: 315

     select TIMEZONE_CODE
     into   p_timezone_code
     from   FND_TIMEZONES_VL
     where  UPGRADE_TZ_ID = p_timezone_id;

Line: 377

             'select ' ||
             'PALLETIZED_LOADING_RATE, ' ||
             'PALLETIZED_UNLOADING_RATE, ' ||
             'NON_PALLETIZED_LOADING_RATE, ' ||
             'NON_PALLETIZED_UNLOADING_RATE, ' ||
             'PALLETIZED_WEIGHT_UOM, ' ||
             'NON_PALLETIZED_WEIGHT_UOM ' ||
             'from MST_PARAMETERS ' ||
             'where USER_ID = :p_global_user_id';

Line: 387

     select COUNT(*)
     into p_is_spliced
     from FND_APPLICATION
     where APPLICATION_SHORT_NAME = 'MST';