DECLARE 
    v_numbers_sit_id_det      NUMBER(10); 
    v_user_numbers_sit_id_det NUMBER(10); 
    v_stud_id                 NUMBER(10); 
    v_user_stud_id            NUMBER(10); 
    v_school_year_id          NUMBER(10); 
    v_school_act_year_id      NUMBER(10); 
    v_school_act_year_deptid  NUMBER(10); 

    CURSOR c_data IS 
      SELECT a. stud_id, 
             a.user_stud_id, 
             a.school_year_id, 
             a.school_act_year_id, 
             a.school_act_year_deptid 
      FROM   std_study_level_students a 
      WHERE  user_stud_id NOT IN (SELECT user_stud_id 
                                  FROM   std_outgoing) 
             AND school_year_id = (SELECT Max (school_year_id) 
                                   FROM   std_study_level_students) 
      ORDER  BY a.school_act_year_id, 
                a.school_act_year_deptid DESC, 
                To_number(user_stud_id); 
BEGIN 
    OPEN c_data; 

    FETCH c_data INTO v_stud_id, v_user_stud_id, v_school_year_id, 
    v_school_act_year_id, v_school_act_year_deptid; 

    INSERT INTO std_numbers_sit_detial 
                (numbers_sit_id_det, 
                 user_numbers_sit_id_det, 
                 numbers_sit_id, 
                 user_stud_id, 
                 stud_id, 
                 number_sit, 
                 school_year_id, 
                 unversity_year, 
                 school_act_year_id, 
                 user_school_act_year_deptid, 
                 semester_id) 
    VALUES      (std_numbers_sit_detial_sq_1.NEXTVAL, 
                 std_numbers_sit_detial_sq_2.NEXTVAL, 
                 :STD_NUMBERS_SIT.numbers_sit_id, 
                 v_user_stud_id, 
                 v_stud_id, 
                 Std_sit_numbers(v_school_act_year_id, v_school_act_year_deptid, 
                 :STD_NUMBERS_SIT.numbers_sit_id), 
                 v_school_year_id, 
                 :STD_NUMBERS_SIT.unversity_year, 
                 v_school_act_year_id, 
                 v_school_act_year_deptid, 
                 :STD_NUMBERS_SIT.semester_id); 

    COMMIT; 

    CLOSE c_data; 
END;