4470: for update of event_id;
4471: --
4472: cursor bookings is
4473: select booking_id 4474: from per_bookings pb 4475: where pb.event_id = l_event_id
4476: for update of booking_id;
4477: --
4478: begin
Line 4504: delete from per_bookings pb
4500: loop
4501: fetch events into l_event_id;
4502: exit when events%NOTFOUND;
4503: -- 4504: delete from per_bookings pb 4505: where pb.event_id = l_event_id;
4506: --
4507: end loop;
4508: close events;