DBA Data[Home] [Help]

APPS.OTA_LO_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES_VL

Line 3026: FROM ota_booking_status_types_vl BST

3022: AND oev.event_id = p_event_id;
3023:
3024: CURSOR c_booking_status IS
3025: SELECT BST.type, BST.name
3026: FROM ota_booking_status_types_vl BST
3027: WHERE BST.booking_status_type_id = p_booking_status_type_id;
3028:
3029: CURSOR c_learning_object_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3030: SELECT lesson_status,

Line 3569: FROM ota_booking_status_types_vl BST

3565: AND oev.event_id = p_event_id;
3566:
3567: CURSOR c_booking_status IS
3568: SELECT BST.type, BST.name
3569: FROM ota_booking_status_types_vl BST
3570: WHERE BST.booking_status_type_id = p_booking_status_type_id;
3571:
3572: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3573: SELECT lesson_status,