The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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);