APPS.OTA_TIMEZONE_UTIL dependencies on OTA_CATEGORY_USAGES

Line 299: l_online_flag ota_category_usages.online_flag%TYPE;

295: ,p_timevalue IN VARCHAR2
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;

Line 317: l_online_flag ota_category_usages.online_flag%TYPE;

313: ,p_timevalue IN VARCHAR2
314: ,p_resource_booking_id IN NUMBER)
315: RETURN DATE
316: IS
317: l_online_flag ota_category_usages.online_flag%TYPE;
318: --l_trb_timezone ota_resource_bookings.timezone%TYPE;
319: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;
320: l_trb_timezone_name fnd_timezones_tl.name%TYPE;
321: BEGIN