DBA Data[Home] [Help]

APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_EVENTS_VL

Line 83: FROM OTA_EVENTS_VL evt,

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

Line 757: FROM ota_events_vl e,

753: CURSOR event_csr (p_event_id ota_events.event_id%TYPE) IS
754: SELECT e.course_start_date,
755: e.course_start_time,
756: e.course_end_date
757: FROM ota_events_vl e,
758: ota_offerings o,
759: ota_activity_versions_tl a
760: WHERE e.parent_offering_id = o.offering_id
761: AND o.activity_version_id = a.activity_version_id

Line 1862: FROM ota_events_vl e,

1858: e.course_start_date,
1859: e.course_start_time,
1860: e.course_end_date,
1861: e.owner_id
1862: FROM ota_events_vl e,
1863: ota_offerings o,
1864: ota_activity_versions_tl a
1865: WHERE e.parent_offering_id = o.offering_id
1866: AND o.activity_version_id = a.activity_version_id