for loopawalrr in
select * from "temporary".tmp_proses_rr_awal
where userid = user_id and status_mapping = 0 order by kode_urut
loop
for loopeod in
select * from "temporary".tmp_tanggal_kolom_rr where userid = user_id
loop
EXECUTE
'update "temporary".tmp_proses_rr_awal tmp
set '||loopeod.tgl ||' = (select sum('||loopeod.tanggal||')
from rpt_summary_eod eod
left join acc_account_number acn on eod.id_akun=acn.id
where eod.bulan_tahun = '''||tahunbulan||'''
and eod.id_bpr = '||var_id_bpr||'
and acn.nomor_akun LIKE '''||loopawalrr.nomor_akun || '%'')
where userid = '||user_id||' and status_mapping = 0 and nomor_akun = '''||loopawalrr.nomor_akun||''';';
end loop;
end loop;
