AND haou.organization_id IN (97,91,140,112) 
                                 AND paaf.organization_id = haou.organization_id

SELECT   TO_CHAR (TO_DATE (pac.segment2, 'rrrr/mm/dd HH24:MI:SS'),
                          'Month'
                         ) MONTH,
                 COUNT (pac.segment1) action_taken
            --to_char(to_date(pac.segment2,'yyyy/mm/dd HH24:MI:SS'),'yyyy') Year
        FROM     per_all_people_f papf,
                 per_all_assignments_f paaf,
                 hr_all_organization_units haou,
                 per_person_analyses ppa,
                 per_analysis_criteria pac
           WHERE papf.person_id = ppa.person_id
             AND paaf.person_id = ppa.person_id
             AND papf.person_id = paaf.person_id
             AND papf.business_group_id=haou.business_group_id
             -- AND paaf.organization_id = haou.organization_id
             AND haou.organization_id IN (SELECT distinct org.organization_id
                                 FROM
                                 hr_all_organization_units org,
                                 per_org_structure_elements pose
                                 WHERE 1=1
                                 AND org.organization_id = pose.organization_id_child
                                 --AND pose.org_structure_version_id = 3067
                                 --and org.name  like '201.Financiale Services'
                                 START WITH
                                 pose.organization_id_parent = :org_id   -- Orgnization of parent id -- provide the id from which level the downward hierarchy should be displaed
                                 CONNECT BY PRIOR
                                 pose.organization_id_child = pose.organization_id_parent
                                 ) 
                                 AND paaf.organization_id = haou.organization_id
             AND ppa.id_flex_num = pac.id_flex_num
             AND ppa.id_flex_num IN (
                    SELECT DISTINCT id_flex_num
                               FROM fnd_id_flex_structures_vl
                              WHERE id_flex_structure_code LIKE
                                       '%AG_Complain_Reg%'
                     -- If name is not there i will add ID_FLEX_STRUCTURE_CODE
                                AND id_flex_code = 'PEA'
                                AND application_id = 800)
             AND ppa.analysis_criteria_id = pac.analysis_criteria_id
             AND to_char(TO_DATE(pac.segment2,'rrrr/mm/dd HH24:MI:SS'),'rrrr') = :yr
             AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
                                     AND papf.effective_end_date
             AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date
                                     AND paaf.effective_end_date
             AND pac.segment7 = 'Y'
        GROUP BY TO_CHAR (TO_DATE (pac.segment2, 'rrrr/mm/dd HH24:MI:SS'),
                          'Month'
                         )