DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on HZ_TIMEZONES

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

195: * doesnt return any value, the API will try to return value of SERVER_TIMEZONE_ID.
196: *
197: * If either of the profiles doesnt return any value, then it returns the first
198: * profile satisfying the condition of being in GMT-8 Offset and also having
199: * Day Light Savings as Yes from HZ_TIMEZONES.
200: *
201: * @return Server Timezone ID (or Zero upon any exception).
202: */
203: FUNCTION get_server_timezone RETURN NUMBER IS

Line 214: FROM hz_timezones

210:
211: IF l_timezone_id IS NULL THEN
212: SELECT MIN(timezone_id)
213: INTO l_timezone_id
214: FROM hz_timezones
215: WHERE gmt_deviation_hours = -8
216: AND daylight_savings_time_flag = 'Y';
217: END IF;
218: