Performance Rating query

SELECT PAPF.EMPLOYEE_NUMBER,
         PAPF.GLOBAL_NAME                     STAFF_NAME,
         to_char(PAPF.START_DATE , 'DD-MON-YYYY') Hire_date,
         A.RATING_MEANING                     RATING,
         TO_CHAR (A.REVIEW_DATE, 'DD-MON-YYYY') REVIEW_DATE,
         A.CREATION_DATE,
         haou.name                            Department
    FROM PER_PERFORMANCE_REVIEWS_V a,
         per_all_people_f        papf,
         per_all_assignments_f   paaf,
         hr_all_organization_units haou
   WHERE     a.person_id = papf.person_id
         AND papf.person_id = paaf.person_id
         AND paaf.organization_id = haou.organization_id
         AND papf.business_group_id = 81
         AND papf.current_employee_flag = 'Y'
         and paaf.primary_flag='Y'
         AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE
                         AND PAPF.EFFECTIVE_END_DATE
         AND SYSDATE BETWEEN PAaF.EFFECTIVE_START_DATE
                         AND PAaF.EFFECTIVE_END_DATE
       --  AND PAPF.EMPLOYEE_NUMBER = NVL (:P_EMP_NO, PAPF.EMPLOYEE_NUMBER)
         AND TO_DATE (A.REVIEW_DATE) > TO_DATE ('30-JUN-2016')
         and to_date(PAPF.START_DATE)<=TO_DATE('30-JUN-2016')
        -- and PAPF.EMPLOYEE_NUMBER ='1376'
ORDER BY PAPF.EMPLOYEE_NUMBER