DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on HZ_TIMEZONES

Line 211: * Day Light Savings as Yes from HZ_TIMEZONES.

207: * doesnt return any value, the API will try to return value of SERVER_TIMEZONE_ID.
208: *
209: * If either of the profiles doesnt return any value, then it returns the first
210: * profile satisfying the condition of being in GMT-8 Offset and also having
211: * Day Light Savings as Yes from HZ_TIMEZONES.
212: *
213: * @return Server Timezone ID (or Zero upon any exception).
214: */
215: FUNCTION get_server_timezone RETURN NUMBER IS

Line 226: FROM hz_timezones

222:
223: IF l_timezone_id IS NULL THEN
224: SELECT MIN(timezone_id)
225: INTO l_timezone_id
226: FROM hz_timezones
227: WHERE gmt_deviation_hours = -8
228: AND daylight_savings_time_flag = 'Y';
229: END IF;
230: