APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_BOOKING_STATUS_TYPES_TL

Line 31: ota_booking_status_types_tl btt

27: bst.booking_status_type_id status_id,
28: decode(bst.type, 'C', 0,'R',1, 'W',2, 'P',3, 'E',4, 'A',5) status_number
29: FROM ota_delegate_bookings tdb,
30: ota_booking_status_types bst,
31: ota_booking_status_types_tl btt
32: WHERE tdb.delegate_person_id = p_learner_id
33: AND tdb.event_id = p_object_id
34: AND tdb.booking_status_type_id = bst.booking_status_type_id
35: AND bst.booking_status_type_id = btt.booking_status_type_id

Line 86: FROM ota_booking_status_types_tl btt

82: ,p_enrollment_status IN VARCHAR2) RETURN VARCHAR2
83: IS
84: CURSOR get_class_enrollment_status IS
85: SELECT btt.name
86: FROM ota_booking_status_types_tl btt
87: WHERE btt.language = USERENV('LANG')
88: AND btt.booking_status_type_id = p_enrollment_status;
89:
90: CURSOR get_subscription_status IS

Line 1527: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt

1523: IS
1524:
1525: CURSOR csr_get_booking_status_id(l_booking_id NUMBER) IS
1526: SELECT btt.booking_status_type_id , btt.name booking_status
1527: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt
1528: WHERE booking_id = l_booking_id
1529: and tdb.booking_status_type_id = btt.booking_status_type_id
1530: and btt.language = USERENV('LANG');
1531:

Line 1554: l_booking_status ota_booking_status_types_tl.name%TYPE;

1550: and nvl(assg.effective_end_date,trunc(sysdate+1));
1551:
1552: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1553: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1554: l_booking_status ota_booking_status_types_tl.name%TYPE;
1555:
1556: l_request_rec csr_get_request_info%ROWTYPE;
1557: l_req_member_rec csr_get_request_members%ROWTYPE;
1558: l_booking_id ota_delegate_bookings.booking_id%TYPE;