DBA Data[Home] [Help]

APPS.OTA_TEA_BUS dependencies on OTA_BOOKING_STATUS_TYPES

Line 696: , ota_booking_status_types b

692: Cursor delegate_count
693: IS
694: select sum(a.number_of_places)
695: from ota_delegate_bookings a
696: , ota_booking_status_types b
697: where a.booking_status_type_id = b.booking_status_type_id
698: and a.customer_id = p_customer
699: and a.event_id = p_event
700: and a.delegate_contact_id is null;