DBA Data[Home] [Help]

APPS.MTH_TZ_UTIL SQL Statements

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

Line: 25

    SELECT tzname INTO from_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = from_tz AND ROWNUM = 1;
Line: 26

    SELECT tzname INTO to_tz_name  FROM V$TIMEZONE_NAMES WHERE tzabbrev = to_tz AND ROWNUM = 1;
Line: 62

    SELECT tzname INTO from_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = from_tz AND ROWNUM = 1;
Line: 97

    SELECT tzname INTO to_tz_name FROM V$TIMEZONE_NAMES WHERE tzabbrev = to_tz AND ROWNUM = 1;