Details of Projects closed in particular period query

SELECT p.segment1 "Project NUMBER", h.NAME " ORGANIZATION",

       pa.full_name "Project Manger", p.start_date, p.closed_date

  FROM pa_projects_all p,

       hr_organization_units h,

       pa_project_players pp,

       per_all_people_f pa

 WHERE 1 = 1

   AND p.project_id = pp.project_id

   --AND p.segment1 = '179250'

   AND p.carrying_out_organization_id = h.organization_id

   AND pa.person_id = pp.person_id

   AND pp.project_role_type = 'PROJECT MANAGER'

---AND p.org_id = 5868

--AND TRUNC (p.closed_date) BETWEEN '01-JUL-2012' AND '31-JUL-2012'