APPS.OTA_TDB_WAITLIST_API SQL Statements

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

Line: 37

  select tdb.booking_id,
         tdb.delegate_person_id,
         tdb.delegate_contact_id,
         tdb.number_of_places,
         tdb.object_version_number,
         tfl.finance_line_id,
         tfl.object_version_number tfl_object_version_number,
         tdb.date_booking_placed  ,
         tdb.internal_booking_flag
  from ota_delegate_bookings tdb,
       ota_booking_status_types bst,
       ota_finance_lines tfl
  where  tfl.booking_id(+) = tdb.booking_id
  and tdb.booking_status_type_id = bst.booking_status_type_id
  and bst.type = 'W'
  and tdb.event_id = p_event_id
  order by tdb.date_booking_placed;

Line: 56

  select tdb.booking_id,
         tdb.delegate_person_id,
         tdb.delegate_contact_id,
         tdb.number_of_places,
         tdb.object_version_number,
         tfl.finance_line_id,
         tfl.object_version_number tfl_object_version_number,
         tdb.date_booking_placed ,
         tdb.internal_booking_flag
  from ota_delegate_bookings tdb,
       ota_booking_status_types bst,
       ota_finance_lines tfl
  where  tfl.booking_id(+)= tdb.booking_id
  and tdb.booking_status_type_id = bst.booking_status_type_id
  and bst.type = 'W'
  and tdb.event_id = p_event_id
  order by tdb.booking_priority,
           tdb.booking_id;

Line: 202

          ota_tdb_api_upd2.update_enrollment(
            p_booking_id                => t_waitlist_table(i).booking_id
           ,p_object_version_number     => t_waitlist_table(i).object_version_number
           ,p_tfl_object_version_number => t_waitlist_table(i).tfl_object_version_number
           ,p_event_id                  => p_event_id
           ,p_finance_line_id           => t_waitlist_table(i).finance_line_id
           ,p_number_of_places          => t_waitlist_table(i).number_of_places
           ,p_date_status_changed       => sysdate    -- bug 1890732
           ,p_booking_status_type_id    => l_status_type_id
           ,p_date_booking_placed        => t_waitlist_table(i).date_booking_placed);