APPS.OTA_OM_TDB_WAITLIST_API dependencies on OTA_DELEGATE_BOOKINGS

Line 80: from ota_delegate_bookings tdb,

76: tfl.finance_line_id,
77: tfl.object_version_number tfl_object_version_number,
78: tdb.date_booking_placed ,
79: tdb.internal_booking_flag
80: from ota_delegate_bookings tdb,
81: ota_booking_status_types bst,
82: ota_finance_lines tfl
83: where tfl.booking_id(+) = tdb.booking_id
84: and tdb.booking_status_type_id = bst.booking_status_type_id

Line 99: from ota_delegate_bookings tdb,

95: tfl.finance_line_id,
96: tfl.object_version_number tfl_object_version_number,
97: tdb.date_booking_placed ,
98: tdb.internal_booking_flag
99: from ota_delegate_bookings tdb,
100: ota_booking_status_types bst,
101: ota_finance_lines tfl
102: where tfl.booking_id(+)= tdb.booking_id
103: and tdb.booking_status_type_id = bst.booking_status_type_id

Line 116: from ota_delegate_bookings a,

112: where event_id = p_event_id;
113:
114: cursor c_places_taken (p_booking_id in number) is
115: select sum(a.number_of_places)
116: from ota_delegate_bookings a,
117: ota_booking_status_types b
118: where a.event_id = p_event_id
119: and a.booking_status_type_id = b.booking_status_type_id
120: and b.type in ('P','A')

Line 128: l_status_type_id ota_delegate_bookings.booking_status_type_id%type;

124:
125: l_proc varchar2(72) := g_package||'AUTO_ENROLL_FROM_WAITLIST';
126: l_count number(9) := 1;
127: l_vacancies number(10);
128: l_status_type_id ota_delegate_bookings.booking_status_type_id%type;
129: l_dummy boolean;
130: l_return_status varchar2(1) := 'T';
131: l_warn boolean := False;
132: l_booking_ovn number;