DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on OTA_TIMEZONE_UTIL

Line 2726: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, timezone)

2722: SELECT null
2723: FROM ota_events
2724: WHERE event_id = p_class_id
2725: --AND trunc(sysdate) between enrolment_start_date and nvl(enrolment_end_date, trunc(sysdate))
2726: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, timezone)
2727: BETWEEN to_date(to_char(nvl(enrolment_start_date,trunc(sysdate)),'YYYY/MM/DD') || ' ' || '00:00' , 'YYYY/MM/DD HH24:MI')
2728: AND to_date(to_char(nvl(enrolment_end_date,to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI')
2729: AND event_type IN ('SCHEDULED', 'SELFPACED')
2730: AND event_status IN ('N', 'P', 'F');