APPS.OTA_EVT_BUS2 SQL Statements

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

Line: 23

select  object_version_number
from    ota_events
where event_id = p_event_id;

Line: 60

select  nvl(sum(number_of_places),0)
from    ota_delegate_bookings tdb
,	ota_booking_status_types bst
,	ota_events evt
where	tdb.event_id = p_event_id
and	evt.event_id = p_event_id
and	tdb.booking_status_type_id = bst.booking_status_type_id
and	bst.type in ('P','A','E')
and	tdb.internal_booking_flag = decode(p_all_or_internal,
				      'INTERNAL','Y',tdb.internal_booking_flag);

Line: 162

select  count(rowid)
from    ota_delegate_bookings odb
where   event_id = p_event_id and
        booking_status_type_id in
        (select booking_status_type_id
         from   ota_booking_status_types
         where  type = 'W');

Line: 172

select  count(rowid)
from    ota_delegate_bookings odb
where   event_id = p_event_id and
	   internal_booking_flag = 'Y' and
        booking_status_type_id in
        (select booking_status_type_id
         from   ota_booking_status_types
         where  type = 'W' );

Line: 240

select  count(resource_booking_id)
from    ota_resource_bookings res
where	res.event_id = p_event_id;

Line: 280

select  nvl(sum(booking_id),0)
from    ota_finance_lines tfl
where	tfl.booking_id = p_booking_id
and	tfl.cancelled_flag = p_cancelled_flag;

Line: 420

      select count(*)
      from
      ota_event_associations
      where
      nvl(mandatory_enrollment_flag,'N')= 'Y' and
      event_id = p_event_id;