DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on JTM_HZ_TIMEZONES_B

Line 1739: from jtm_hz_timezones_b where timezone_id=l_server_tz;

1735: next_day(add_months('1-JAN'||to_char(sysdate,'YYYY'),end_dst_month-1) + ((end_dst_week_of_month-1)*7)-1,
1736: decode(end_dst_day_of_week, 1,'SUNDAY',2,'MONDAY',3,'TUESDAY',4,'WEDNESDAY',5,'THURSDAY',6,'FRIDAY',7,'SATURDAY')) + (end_dst_hour/24) DST_END_DATE,
1737: GMT_DEVIATION_HOURS,DST_INCREMENT
1738: into l_dst_begin,l_dst_end,l_deviation,l_increment
1739: from jtm_hz_timezones_b where timezone_id=l_server_tz;
1740:
1741: IF(p_date between l_dst_begin and l_dst_end) THEN
1742: l_deviation := l_deviation + l_increment;
1743: END IF;