APPS.OTA_TDB_BUS dependencies on OTA_OFFERINGS

Line 3411: FROM ota_offerings oft

3407: CURSOR csr_get_class_type(p_class_id NUMBER) IS
3408: SELECT oft.learning_object_id
3409: ,ctu.online_flag
3410: ,evt.offering_id
3411: FROM ota_offerings oft
3412: , ota_events evt
3413: , ota_category_usages ctu
3414: WHERE oft.offering_id = evt.parent_offering_id
3415: AND ctu.category_usage_id = oft.delivery_mode_id

Line 3419: l_lo_id ota_offerings.learning_object_id%TYPE;

3415: AND ctu.category_usage_id = oft.delivery_mode_id
3416: AND evt.event_id = p_class_id;
3417:
3418: l_online_flag VARCHAR2(9) := NULL;
3419: l_lo_id ota_offerings.learning_object_id%TYPE;
3420: l_imported_off_id ota_events.offering_id%TYPE;
3421: l_bkng_status_type VARCHAR2(30);
3422: l_old_bst VARCHAR2(30);
3423: