APPS.OTA_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES

Line 634: FROM OTA_BOOKING_STATUS_TYPES

630:
631:
632: CURSOR c_status_type IS
633: SELECT Type
634: FROM OTA_BOOKING_STATUS_TYPES
635: WHERE booking_status_type_id = p_status_type_id;
636:
637: l_status_type ota_booking_status_types.type%type ;
638:

Line 637: l_status_type ota_booking_status_types.type%type ;

633: SELECT Type
634: FROM OTA_BOOKING_STATUS_TYPES
635: WHERE booking_status_type_id = p_status_type_id;
636:
637: l_status_type ota_booking_status_types.type%type ;
638:
639:
640: BEGIN
641: hr_utility.set_location('Entering:'||l_proc, 5);

Line 990: ota_booking_status_types bst,

986: --
987: cursor c_other_person_bookings is
988: select bst.type
989: from ota_delegate_bookings db,
990: ota_booking_status_types bst,
991: ota_events ev,
992: ota_events evt
993: where db.delegate_person_id = p_delegate_person_id
994: and db.booking_status_type_id = bst.booking_status_type_id

Line 1017: ota_booking_status_types bst,

1013: --
1014: cursor c_other_contact_bookings is
1015: select bst.type
1016: from ota_delegate_bookings db,
1017: ota_booking_status_types bst,
1018: ota_events ev,
1019: ota_events evt
1020: where db.delegate_contact_id = p_delegate_contact_id
1021: and db.booking_status_type_id = bst.booking_status_type_id

Line 1417: FROM ota_booking_status_types bst

1413: INTO l_num_waitlisted
1414: FROM ota_delegate_bookings tdb
1415: WHERE tdb.event_id = p_event_id
1416: AND tdb.booking_status_type_id IN (SELECT bst.booking_status_type_id
1417: FROM ota_booking_status_types bst
1418: WHERE bst.type = 'W');
1419: hr_utility.set_location('Leaving :'||l_proc,10);
1420: RETURN l_num_waitlisted;
1421:

Line 1458: ota_booking_status_types bst

1454:
1455: CURSOR c_date_waitlist is
1456: SELECT tdb.booking_id
1457: FROM ota_delegate_bookings tdb,
1458: ota_booking_status_types bst
1459: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1460: AND bst.type = 'W'
1461: AND tdb.event_id = p_event_id
1462: ORDER BY tdb.date_booking_placed;

Line 1467: ota_booking_status_types bst

1463:
1464: CURSOR c_priority_waitlist is
1465: SELECT tdb.booking_id
1466: FROM ota_delegate_bookings tdb,
1467: ota_booking_status_types bst
1468: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1469: AND bst.type = 'W'
1470: AND tdb.event_id = p_event_id
1471: ORDER BY tdb.booking_priority,

Line 2149: FROM ota_booking_status_types_vl BST,

2145: RETURN VARCHAR2 IS
2146:
2147: CURSOR enroll_status IS
2148: SELECT DECODE(BST.type,'C','Y',BST.type) status, BST.name
2149: FROM ota_booking_status_types_vl BST,
2150: ota_delegate_bookings ODB
2151: WHERE ODB.event_id = p_event_id
2152: AND (p_delegate_person_id IS NOT NULL AND ODB.delegate_person_id = p_delegate_person_id
2153: OR p_delegate_contact_id IS NOT NULL and ODB.delegate_contact_id = p_delegate_contact_id)

Line 2161: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

2157:
2158: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
2159:
2160: l_enrollment_status VARCHAR2(30) := 'Z'; --Default is Not Enrolled(Status Z)
2161: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
2162:
2163: BEGIN
2164: hr_utility.set_location(' Step:'|| l_proc, 10);
2165: