DBA Data[Home] [Help]

APPS.OTA_EVT_BUS2 dependencies on OTA_EVENTS

Line 24: from ota_events

20: l_evt_object_version_number number;
21: --
22: cursor get_event is
23: select object_version_number
24: from ota_events
25: where event_id = p_event_id;
26: --
27: l_proc varchar2(72) := g_package||'lock_event';
28: --

Line 63: , ota_events evt

59: cursor get_total_places is
60: select nvl(sum(number_of_places),0)
61: from ota_delegate_bookings tdb
62: , ota_booking_status_types bst
63: , ota_events evt
64: where tdb.event_id = p_event_id
65: and evt.event_id = p_event_id
66: and tdb.booking_status_type_id = bst.booking_status_type_id
67: and bst.type in ('P','A','E')