getting error while fetching multiple records in plsql

Hello Experts,

Oracle DB Version: 11.2.0.1

we have a requirement to fetch the ids from the cursor and pass it query and based on calculation, it will insert the records into particular table. Please find all the details as below,

Table Creation and insertion scripts:

create table table_a(e_id number, item_id number,quantity number)

/

create table table_b(v_name varchar2(100))

/

create table table_c(e_id number, flm number)

/

create table table_d(v_name varchar2(100),allocation number)

/

create table table_e(e_id number,quantity number)

/

insert into table_a values(1,123,1000)

/

insert into table_b values('ABC1')