DBA Data[Home] [Help]

APPS.OTA_LO_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES_VL

Line 3391: FROM ota_booking_status_types_vl BST

3387: AND oev.event_id = p_event_id;
3388:
3389: CURSOR c_booking_status IS
3390: SELECT BST.type, BST.name
3391: FROM ota_booking_status_types_vl BST
3392: WHERE BST.booking_status_type_id = p_booking_status_type_id;
3393:
3394: CURSOR c_learning_object_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3395: SELECT lesson_status,

Line 4065: FROM ota_booking_status_types_vl BST

4061: AND oev.event_id = p_event_id;
4062:
4063: CURSOR c_booking_status IS
4064: SELECT BST.type, BST.name
4065: FROM ota_booking_status_types_vl BST
4066: WHERE BST.booking_status_type_id = p_booking_status_type_id;
4067:
4068: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
4069: SELECT lesson_status,