Employee Bank Account Details In HRMS

SELECT DISTINCT PAPF.PERSON_ID,
                  PAPF.EMPLOYEE_NUMBER,
                  PAAF.ASSIGNMENT_ID,
                  papf.full_name,
                  hl.meaning Bank_name,
                  --pea.segment3,
                  pea.segment1 Acc_no,
                  pea.segment2 Acc_type,
                  pp.BUSINESS_GROUP_ID
    FROM PER_ALL_PEOPLE_F PAPF,
         PER_ALL_ASSIGNMENTS_F PAAF,
         hr_lookups hl,
         pay_external_accounts pea,
         pay_personal_payment_methods_f pp
   WHERE     hl.lookup_code = pea.segment3
         AND pp.external_account_id = pea.external_account_id
         AND PAPF.PERSON_ID = PAAF.PERSON_ID
         AND pp.assignment_id = paaf.assignment_id
         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 TRUNC (SYSDATE) BETWEEN pp.effective_start_date
                                 AND pp.effective_end_date
         AND PAPF.CURRENT_EMPLOYEE_FLAG = 'Y'
         AND PAAF.PRIMARY_FLAG = 'Y'
         AND papf.employee_number = NVL (:p_employee_Num, papf.employee_number)
         AND hl.LOOKUP_TYPE = 'MX_BANK'
--AND hl.meaning = NVL (:P_Bank_Name, hl.meaning)
--AND pea.segment1 = NVL (:P_Bank_Accc_Num, pea.segment1)
--and papf.employee_number = 500013
ORDER BY PAPF.EMPLOYEE_NUMBER;