APPS.OTA_TIMEZONE_UTIL SQL Statements

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

Line: 40

  SELECT UPGRADE_TZ_ID
  FROM fnd_timezones_b
  WHERE timezone_code = p_timezone_code;

Line: 58

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

Line: 79

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

Line: 88

    SELECT DBTIMEZONE INTO l_db_timezone FROM DUAL;

Line: 111

   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: 132

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

Line: 262

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