sum(nvl(credit,0)) from raak_trans_Detail where raak_trans_detail.ledger_name = balance_sheet.ledger_name);
update balance_sheet set asset = (select sum(nvl(debit,0))
from raak_trans_detail
where raak_trans_detail.ledger_name =
balance_sheet.ledger_name);
update balance_sheet set liability = (liability - asset), asset= null where liability > nvl(asset,0);
update balance_sheet set asset = (asset - liability), liability = null where asset > nvl(liability,0); select sum(asset) - sum(liability) into pl from balance_sheet;
if pl > 0 then
update balance_sheet set liability = pl where ledger_name like 'ACCUMULATED PROFIT';
else
update balance_sheet set ASSET = pl*-1 where ledger_name like 'ACCUMULATED LOSS';
end if;
delete from balance_sheet where nvl(liability,0) = 0 and nvl(asset,0) = 0;
delete from profit_loss;
insert into profit_loss (ledger_name) select ledger_name from raak_ledger_master
where report_type='PL';
update profit_loss set income = (select sum(nvl(credit,0))
from raak_trans_detail
where raak_trans_detail.ledger_name =
profit_loss.ledger_name);