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
85: and bst.type = 'W'
86: and tdb.event_id = p_event_id
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
104: and bst.type = 'W'
105: and tdb.event_id = p_event_id