[Home] [Help]
1799: sum(nvl(total_billed_amount,0))
1800: INTO x_total_funding_amount,
1801: x_total_revenue_amount,
1802: x_total_billed_amount
1803: FROM gms_summary_project_fundings gspf,
1804: gms_installments ins
1805: WHERE ins.installment_id = gspf.installment_id
1806: and ins.award_id = St_award_id;
1807: