APPS.OTA_TIMEZONE_UTIL SQL Statements

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

Line: 41

  SELECT UPGRADE_TZ_ID
  FROM fnd_timezones_b
  WHERE timezone_code = p_timezone_code;

Line: 59

   SELECT timezone_code
          ,name
   FROM fnd_timezones_vl
   WHERE UPGRADE_TZ_ID = fnd_profile.VALUE ('CLIENT_TIMEZONE_ID');

Line: 80

  SELECT timezone_code
  FROM FND_TIMEZONES_B
  WHERE GMT_OFFSET = p_offset
    AND enabled_flag = 'Y';

Line: 89

    SELECT DBTIMEZONE INTO l_db_timezone FROM DUAL;

Line: 112

   SELECT timezone_code
          ,name
   FROM  fnd_timezones_tl ftt
        ,ota_events evt
   WHERE event_id = p_event_id
     AND evt.timezone = ftt.timezone_code
     AND ftt.language = userenv('LANG');

Line: 133

   SELECT name
   FROM fnd_timezones_tl
   WHERE timezone_code = p_timezone_code
    AND LANGUAGE = userenv('LANG');

Line: 263

     SELECT NLS_LANGUAGE
     FROM fnd_languages
     WHERE language_code = userenv('LANG');