155: l_event_title ota_events.title%type;
156: l_course_start_date ota_events.course_start_date%type;
157: l_course_start_time ota_events.course_start_time%type;
158: l_course_end_date ota_events.course_end_date%type;
159: l_delivery_mode ota_category_usages_tl.category%type;
160: l_event_location hr_locations_all.location_code%TYPE;
161: l_version_name ota_activity_versions.version_name%type;
162:
163: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
182: ctl.category,
183: ota_general.get_location_code(oev.location_id) Location_Name,
184: oav.version_name,ota_timezone_util.get_timezone_name(oev.timezone),oev.course_end_time
185: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav,
186: OTA_CATEGORY_USAGES_TL ctl,ota_offerings off
187: where oev.event_id = evt.event_id
188: and oev.parent_offering_id=off.offering_id
189: and off.activity_version_id= oav.activity_version_id
190: and ctl.Category_usage_id = off.delivery_mode_id