Query to find the project status and agreement

SELECT ppf.project_number,
ppf.project_name,
pps. project_status_name project_status,
paa.agreement_num,
paa.DESCRIPTION
FROM pa_agreements_all paa,
pa_project_fundings_v ppf,
pa_projects_all ppa,
pa_project_statuses pps
WHERE paa.agreement_id = ppf.agreement_id
AND ppa.project_status_code = pps.project_status_code
AND ppa.project_id = ppf.project_id
and ppa.org_id = paa.org_id
and ppa.org_id =111