DBA Data[Home] [Help]

APPS.OTA_EVT_API_UPD2 dependencies on OTA_DELEGATE_BOOKINGS

Line 24: FROM ota_delegate_bookings odb

20: --
21: -- Bug 3493695
22: CURSOR c_attended_enr IS
23: SELECT null
24: FROM ota_delegate_bookings odb
25: WHERE event_id = p_event_id AND
26: booking_status_type_id IN
27: (SELECT booking_status_type_id
28: FROM ota_booking_status_types

Line 141: from ota_delegate_bookings odb

137: l_no_of_waitlist_candidate number;
138:
139: cursor c_check_waitlist_candidates is
140: select count(*)
141: from ota_delegate_bookings odb
142: where event_id = p_event_id and
143: booking_status_type_id in
144: (select booking_status_type_id
145: from ota_booking_status_types

Line 226: from ota_delegate_bookings tdb

222: select tdb.booking_id, tdb.object_version_number, fl.object_version_number tfl_object_version_number,
223: fl.finance_line_id,
224: date_booking_placed, line_id,org_id,daemon_flag,daemon_type, tdb.booking_status_type_id,
225: tdb.delegate_person_id
226: from ota_delegate_bookings tdb
227: , ota_booking_status_types bst
228: , ota_finance_lines fl
229: where tdb.event_id = p_event_id
230: and tdb.booking_status_type_id = bst.booking_status_type_id