APPS.OTA_EVT_API_UPD2 dependencies on OTA_BOOKING_STATUS_TYPES

Line 28: FROM ota_booking_status_types

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
29: WHERE type = 'A');
30:
31: l_att_enr_exists VARCHAR2(1);
32: -- Bug 3493695

Line 145: from ota_booking_status_types

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
146: where type = 'W');
147:
148: --
149: begin

Line 227: , ota_booking_status_types bst

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
231: and fl.booking_id(+) = tdb.booking_id

Line 238: from ota_booking_status_types

234: or ((p_event_status = 'A') and (bst.type <> 'C'))); -- Added check for "bst.type <> 'C'" for bug #2065808
235:
236: CURSOR c_get_booking_status(p_booking_status_type_id in number) is
237: select type
238: from ota_booking_status_types
239: where booking_status_type_id = p_booking_status_type_id;
240:
241:
242: --