DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES_VL

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)