APPS.OTA_VIEWS_PKG dependencies on OTA_BOOKING_STATUS_TYPES

Line 22: , ota_booking_status_types bst

18: BEGIN
19: select nvl(sum(db.number_of_places),0)
20: into l_places_booked
21: from ota_delegate_bookings db
22: , ota_booking_status_types bst
23: where bst.booking_status_type_id = db.booking_status_type_id
24: and ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1
25: and db.event_id = p_event_id ;
26:

Line 30: , ota_booking_status_types bst

26:
27: select nvl(sum(db.number_of_places),0)
28: into l_place_wait
29: from ota_delegate_bookings db
30: , ota_booking_status_types bst
31: where bst.booking_status_type_id = db.booking_status_type_id
32: and bst.type = 'W'
33: and db.event_id = p_event_id ;
34:

Line 39: , ota_booking_status_types bst

35:
36: select nvl(sum(db.number_of_places),0)
37: into l_internal_places_booked
38: from ota_delegate_bookings db
39: , ota_booking_status_types bst
40: where bst.booking_status_type_id = db.booking_status_type_id
41: and ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1
42: and db.internal_booking_flag='Y'
43: and db.event_id = p_event_id ;