APPS.OTA_VIEWS_PKG SQL Statements

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

Line: 19

   select nvl(sum(db.number_of_places),0)
   into   l_places_booked
   from   ota_delegate_bookings db
   ,      ota_booking_status_types bst
   where  bst.booking_status_type_id = db.booking_status_type_id
   and    ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1
   and    db.event_id = p_event_id ;

Line: 27

   select nvl(sum(db.number_of_places),0)
   into   l_place_wait
   from   ota_delegate_bookings db
   ,      ota_booking_status_types bst
   where  bst.booking_status_type_id = db.booking_status_type_id
   and    bst.type = 'W'
   and    db.event_id = p_event_id ;

Line: 36

   select nvl(sum(db.number_of_places),0)
   into   l_internal_places_booked
   from   ota_delegate_bookings db
   ,      ota_booking_status_types bst
   where  bst.booking_status_type_id = db.booking_status_type_id
   and    ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1
   and    db.internal_booking_flag='Y'
   and    db.event_id = p_event_id ;

Line: 45

   select nvl(maximum_attendees,0)
   into   l_max_places
   from   ota_events
   where  event_id = p_event_id ;

Line: 50

   select nvl(maximum_internal_attendees, -1)
   into l_max_internal_places
   from ota_events
   where event_id = p_event_id;

Line: 55

   select event_status
   into l_event_status
   from ota_events
   where event_id = p_event_id;