APPS.OTA_TIMEZONE_UTIL dependencies on OTA_EVENTS

Line 115: ,ota_events evt

111: CURSOR csr_get_evt_tzvals IS
112: SELECT timezone_code
113: ,name
114: FROM fnd_timezones_tl ftt
115: ,ota_events evt
116: WHERE event_id = p_event_id
117: AND evt.timezone = ftt.timezone_code
118: AND ftt.language = userenv('LANG');
119:

Line 301: l_evt_timezone ota_events.timezone%TYPE;

297: ,p_event_id IN NUMBER)
298: RETURN DATE
299: IS
300: l_online_flag ota_category_usages.online_flag%TYPE;
301: l_evt_timezone ota_events.timezone%TYPE;
302: BEGIN
303: OPEN get_class_info(p_event_id);
304: FETCH get_class_info INTO l_online_flag, l_evt_timezone;
305: CLOSE get_class_info;