eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OLTP_DISC_TRAINING dependencies on OTA_BOOKING_STATUS_TYPES

Line 363: ota_booking_status_types bst

359:
360: CURSOR internal_bookings_csr is
361: SELECT NVL(SUM(NVL(tdb.number_of_places,1)),0)
362: FROM
363: ota_booking_status_types bst
364: ,ota_delegate_bookings tdb
365: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
366: AND bst.type = 'A' -- Attended
367: AND tdb.organization_id IS NOT NULL

Line 422: FROM ota_booking_status_types bst

418: RETURN NUMBER IS
419:
420: CURSOR external_bookings_csr is
421: SELECT tdb.booking_id
422: FROM ota_booking_status_types bst
423: ,ota_delegate_bookings tdb
424: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
425: AND bst.type = 'A' -- Attended
426: AND tdb.customer_id is not null

Line 496: FROM ota_booking_status_types bst

492: WHERE event_id = p_event_id;
493:
494: CURSOR internal_bookings_csr is
495: SELECT NVL(SUM(NVL(tdb.number_of_places,1)),0)
496: FROM ota_booking_status_types bst
497: ,ota_delegate_bookings tdb
498: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
499: AND bst.type = 'A' -- AttENDed
500: AND tdb.organization_id IS NOT NULL

Line 564: FROM ota_booking_status_types bst

560: RETURN NUMBER IS
561:
562: CURSOR external_bookings_csr IS
563: SELECT tdb.booking_id
564: FROM ota_booking_status_types bst
565: ,ota_delegate_bookings tdb
566: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
567: AND bst.type = 'A' -- Attended
568: AND tdb.booking_id = p_booking_id

Line 643: FROM ota_booking_status_types bst

639: WHERE event_id = p_event_id;
640:
641: CURSOR internal_bookings_csr is
642: SELECT NVL(SUM(NVL(tdb.number_of_places,1)),0)
643: FROM ota_booking_status_types bst
644: ,ota_delegate_bookings tdb
645: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
646: AND bst.type IN ('P','C') -- Placed, Cancelled
647: AND tdb.organization_id IS NOT NULL

Line 711: FROM ota_booking_status_types bst

707: RETURN NUMBER IS
708:
709: CURSOR external_bookings_csr is
710: SELECT tdb.booking_id
711: FROM ota_booking_status_types bst
712: ,ota_delegate_bookings tdb
713: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
714: AND bst.type IN ('P','C') -- Placed, Cancelled
715: AND tdb.booking_id = p_booking_id