APPS.OTA_OM_UTIL dependencies on OTA_ACTIVITY_VERSIONS_TL

Line 31: ota_activity_versions_tl act -- MLS change _tl added

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:
35:

Line 42: ota_activity_versions_tl act, --MLS change _tl added

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
46: AND dlb.line_id = p_line_id;