5079: for update of event_id;
5080: --
5081: cursor bookings is
5082: select booking_id 5083: from per_bookings pb 5084: where pb.event_id = l_event_id
5085: for update of booking_id;
5086: --
5087: begin
Line 5113: delete from per_bookings pb
5109: loop
5110: fetch events into l_event_id;
5111: exit when events%NOTFOUND;
5112: -- 5113: delete from per_bookings pb 5114: where pb.event_id = l_event_id;
5115: --
5116: end loop;
5117: close events;