DBA Data[Home] [Help]

APPS.OTA_ILEARNING dependencies on OTA_BOOKING_STATUS_TYPES

Line 675: FROM ota_booking_status_types

671: cursor cur_waitlist_size is
672: select count(*)
673: from ota_delegate_bookings
674: where booking_status_type_id in (SELECT booking_status_type_id
675: FROM ota_booking_status_types
676: WHERE type = 'W')
677: and event_id = l_event_id;
678:
679:

Line 684: FROM ota_booking_status_types

680: cursor cur_get_total_placed is
681: select count(*)
682: from ota_delegate_bookings
683: where booking_status_type_id in (SELECT booking_status_type_id
684: FROM ota_booking_status_types
685: WHERE type in ('A','P','E'))
686: and event_id = l_event_id;
687:
688: