1708: sum(initial_funding_amount
1709: + additional_funding_amount
1710: + cancelled_funding_amount
1711: + funding_adjustment_amount) total_fund
1712: FROM pji_ac_xbs_accum_f f,
1713: pa_projects_all ppa
1714: WHERE f.project_id = ppa.project_id
1715: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1716: AND f.currency_code = ppa.projfunc_currency_code
2274: FOR i in v_project_id.FIRST..v_project_id.LAST loop
2275: delete PJI_FP_XBS_ACCUM_F where project_id = v_project_id(i);
2276: commit;
2277:
2278: delete PJI_AC_XBS_ACCUM_F where project_id = v_project_id(i);
2279: commit;
2280:
2281: END LOOP;
2282: close get_projects_for_fact_deletion;