create table fees1 (
chl     number(7),ffdat date,
sno     number(5),ftut    number(6),ftot number(6));

insert into fees1 
values
(123,'01-OCT-2024',1,1300,1300);

insert into fees1 
values
(123,'11-OCT-2024',2,1500,1500);

insert into fees1 
values
(124,'03-OCT-2024',1,1500,1500);


insert into fees1 
values
(124,'09-OCT-2024',2,1500,1500);

insert into fees1 
values
(223,'02-OCT-2024',1,1500,1500);

insert into fees1 
values
(224,'04-OCT-2024',1,1700,1700);

COMMIT;

Begin
If Populate_Group_With_Query('R_G','Select fdate,ftut,ftot from fees1
Where chl=:chl_no 
Order by fdate') Then
Clear_List('Std');
Populate_List('fees1.fdate','R_G');
Populate_List('fees1.ftut','R_G');
Populate_List('fees1.ftot','R_G');
End if;
Exception
When Others Then
Message(Sqlerrm);
End;}