sql 存储过程 for in loop 使用 业务

declare
 begin
 for tttt in
  (select temp.c_id
                   from (select cst.c_tci_id, max(ins.T_END_DATE) as endDate
                           from tb_test_1 t1, tb_test_2 t2
                          where t1.c_id = t2.c_id
                            and t1.C_DEL = '0'
                            group by c_tci_id) temp
                  where endDate < sysdate)
      loop
           update tb_test_1 t1
              set t1.c_stat ='0'
            where t1.c_id = tttt.c_id;
            --commit;
      end loop;
      end;

--
declare
 begin
 for thecst in
  (select temp.c_tci_id
                   from (select cst.c_tci_id, max(ins.T_END_DATE) as insDate
                           from tb_test1 cst, tb_test2 ins
                          where cst.c_tci_id = ins.c_cst_id
                            and cst.C_DEL = '0'
                            --and cst.c_stat = '0'
                            and cst.C_NO_RELEASE = '1' 
                            and ins.C_DEL = '0'
                            and ins.c_stat is null
                            and ins.c_is_telesale_ply is null
                            group by c_tci_id) temp 
                  where insDate < sysdate  
                  and  temp.c_tci_id not in
                    (select cst.c_tci_id
                                from tb_cst_info cst, tb_ins_info ins
                               where cst.c_tci_id = ins.c_cst_id
                                )
                  )
      loop
           update tb_test1 cst
              set cst.C_NO_RELEASE = '0',cst.T_NO_RELEASE_TIME = sysdate, cst.c_stat ='0'
            where cst.c_tci_id = thecst.c_tci_id;
            --commit;
      end loop;
      end;