create table xx(id number(4),name varchar2(20);
insert into xx values(1,'aa');
insert into xx values(1,'bb');
insert into xx values(2,'cc');
insert into xx values(3,'gg');
insert into xx values(4,'uu');

declare
cursor c1 is select name from xx where id=1 and rownum not in(1,2);
begin
 dbms_output.put_line('begun');
 for rec in c1 loop
  dbms_output.put_line(rec.name);

end loop;

end;

SQL> SET UNDERLINE ON
SQL> @my
Enter value for fi_shortname: SS
Enter value for fi_shortname: SS
Enter value for fi_shortname: SS

FI Name   Customer Name  User Name
--------------------------------------------
"INTFI73","GCUST13","CUSER1"
"INTFI73","GCUSTCORP1","CUSERSB1"
"INTFI73","CUST_CORP1","DUPUSER1"
"INTFI73","CUST_CORP2","DUPUSER2"
"INTFI73","GCUST12","CUSER1"
"INTFI73","GCUSTSB1","CUSERSB1"
"INTFI73","CUST_SB1","DUPUSER1"
"INTFI73","CUST_SB2","DUPUSER2"