APPS.OTA_EVENT_ASSOCIATIONS_PKG dependencies on OTA_BOOKING_STATUS_TYPES

Line 28: ota_booking_status_types bst,

24: cursor c_places_used is
25: select nvl(sum(number_of_places),0)
26: from ota_delegate_bookings tdb,
27: ota_finance_lines fin,
28: ota_booking_status_types bst,
29: ota_events evt
30: where fin.booking_deal_id = p_booking_deal_id
31: and fin.cancelled_flag = 'N'
32: and fin.booking_id = tdb.booking_id

Line 131: from ota_booking_status_types

127: l_create_finance_line varchar2(1);
128: l_type varchar2(10);
129: cursor c1 is
130: select type
131: from ota_booking_status_types
132: where booking_status_type_id = p_booking_status_type_id;
133: --
134: begin
135: --