Query to get employee payment method in oracle hrms

SELECT pap.employee_number, pap.full_name, pap.person_id, paf.assignment_id,
       pam.org_payment_method_name, pay.percentage, pay.priority,
       pea.segment1 bank_name, pea.segment2 branch, pea.segment3 account_type,
       pea.segment4 iban, pea.segment5 ACCOUNT
  FROM pay_personal_payment_methods_f pay,
       pay_org_payment_methods_f pam,
       pay_external_accounts pea,
       per_all_assignments_f paf,
       per_all_people_f pap
 -- Hr_lookups hrl
WHERE  pay.org_payment_method_id = pam.org_payment_method_id
   AND paf.assignment_id = pay.assignment_id
   AND paf.person_id = pap.person_id
   AND TRUNC (SYSDATE) BETWEEN pap.effective_start_date AND pap.effective_end_date
   AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
   AND TRUNC (SYSDATE) BETWEEN pay.effective_start_date AND pay.effective_end_date
   AND TRUNC (SYSDATE) BETWEEN pam.effective_start_date AND pam.effective_end_date
   AND paf.primary_flag = 'Y'
   AND pea.external_account_id = pay.external_account_id