DBA Data[Home] [Help]

APPS.OTA_OM_UTIL dependencies on OTA_EVENTS_VL

Line 30: FROM ota_events_vl evt, -- MLS change _vl added

26: SELECT act.version_name,
27: evt.title,
28: evt.course_start_date,
29: evt.course_end_date
30: FROM ota_events_vl evt, -- MLS change _vl added
31: ota_activity_versions_tl act -- MLS change _tl added
32: WHERE act.activity_version_id = evt.activity_version_id
33: AND evt.line_id = p_line_id;
34:

Line 41: FROM ota_events_vl evt, -- MLS change _vl added

37: SELECT act.version_name,
38: evt.title,
39: evt.course_start_date,
40: evt.course_end_date
41: FROM ota_events_vl evt, -- MLS change _vl added
42: ota_activity_versions_tl act, --MLS change _tl added
43: ota_delegate_bookings dlb
44: WHERE act.activity_version_id = evt.activity_version_id
45: AND dlb.event_id = evt.event_id