[Home] [Help]
79: evt.Title,
80: evt.owner_id,
81: off.activity_version_id,
82: evt.offering_id
83: FROM OTA_EVENTS_VL evt,
84: OTA_OFFERINGS off,
85: HR_ALL_ORGANIZATION_UNITS hao
86: WHERE evt.event_id = pp_event_id
87: AND off.offering_id = evt.parent_offering_id
752: CURSOR event_csr (p_event_id ota_events.event_id%TYPE) IS
753: SELECT e.course_start_date,
754: e.course_start_time,
755: e.course_end_date
756: FROM ota_events_vl e,
757: ota_offerings o,
758: ota_activity_versions_tl a
759: WHERE e.parent_offering_id = o.offering_id
760: AND o.activity_version_id = a.activity_version_id
1857: e.course_start_date,
1858: e.course_start_time,
1859: e.course_end_date,
1860: e.owner_id
1861: FROM ota_events_vl e,
1862: ota_offerings o,
1863: ota_activity_versions_tl a
1864: WHERE e.parent_offering_id = o.offering_id
1865: AND o.activity_version_id = a.activity_version_id