oracle 循环的一种写法

for v_n in(
select bb.temNum, bb.LOANTYPE
from (select decode(bns.assignstate,
'{016D68F9-719B-4EFC-A1C3-3DAB06DEE888}',
1,
'{CF281EE7-DE45-44F0-AABD-DC06B666E5EF}',
2) temNum,
sl.LOANTYPE
from salaryloanaudit sl
inner join businessassign bns
on sl.formguid = bns.loanguid
where bns.assignstate in
('{016D68F9-719B-4EFC-A1C3-3DAB06DEE888}', --审批通过 
'{CF281EE7-DE45-44F0-AABD-DC06B666E5EF}') --审批拒绝
and bns.active = '1'
and sl.formguid = v_formguid) bb
) loop 

statenum:=v_n.temnum;
stateStr:=v_n.loantype;

end loop;