1720: GROUP BY f.project_id
1721: )
1722: report ,
1723: pa_projects_all pa,
1724: pa_project_statuses pps
1725: WHERE pa.project_id = base_fund.project_id
1726: and pa.project_id = base_rev.project_id
1727: AND base_rev.project_id = report.project_id
1728: AND base_fund.project_id = report.project_id