APPS.OTA_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES_VL

Line 696: FROM OTA_BOOKING_STATUS_TYPES_VL

692:
693:
694: CURSOR c_status_type IS
695: SELECT name
696: FROM OTA_BOOKING_STATUS_TYPES_VL
697: WHERE booking_status_type_id = p_status_type_id;
698:
699: l_status_name ota_booking_status_types.name%type ;
700:

Line 2213: FROM ota_booking_status_types_vl BST,

2209: RETURN VARCHAR2 IS
2210:
2211: CURSOR enroll_status IS
2212: SELECT DECODE(BST.type,'C','Y',BST.type) status, BST.name
2213: FROM ota_booking_status_types_vl BST,
2214: ota_delegate_bookings ODB
2215: WHERE ODB.event_id = p_event_id
2216: AND (p_delegate_person_id IS NOT NULL AND ODB.delegate_person_id = p_delegate_person_id
2217: OR p_delegate_contact_id IS NOT NULL and ODB.delegate_contact_id = p_delegate_contact_id)