APPS.OTA_TIMEZONE_UTIL dependencies on OTA_EVENTS

Line 114: ,ota_events evt

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

Line 300: l_evt_timezone ota_events.timezone%TYPE;

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