APPS.OTA_OM_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

  SELECT act.version_name,
	 evt.title,
	 evt.course_start_date,
	 evt.course_end_date
    FROM ota_events_vl evt,  -- MLS change _vl added
	 ota_activity_versions_tl act -- MLS change _tl added
   WHERE act.activity_version_id = evt.activity_version_id
     AND evt.line_id = p_line_id;

Line: 37

  SELECT act.version_name,
	 evt.title,
	 evt.course_start_date,
	 evt.course_end_date
    FROM ota_events_vl evt, -- MLS change _vl added
	 ota_activity_versions_tl act, --MLS change _tl added
	 ota_delegate_bookings dlb
   WHERE act.activity_version_id = evt.activity_version_id
     AND dlb.event_id = evt.event_id
     AND dlb.line_id = p_line_id;