open cursor; ---some statements close;

open cursor; fetch into variables; ---some statements close cursor;

open cursor; fetch into variables; ---some statements close;

All of the above