Query to Fetch the customer account related bank details

SELECT ipiu.instrument_payment_use_id,

       ipiu.payment_flow,

       ipiu.ext_pmt_party_id,

       ipiu.instrument_type,

       ipiu.instrument_id,

       cb.bank_name,

       cb.bank_branch_name,

       ieb.currency_code,

       ieb.bank_account_name,

       ieb.bank_account_num,

       ipiu.payment_function,

       DECODE (ipiu.order_of_preference, 1, 'YES', 'NO') primary_flag,

       ieb.start_date,

       ieb.end_date,

       ipiu.debit_auth_flag,

       ipiu.debit_auth_method,

       ipiu.debit_auth_reference,

       ipiu.debit_auth_begin,

       ipiu.debit_auth_end,

       iep.org_id

  FROM iby_pmt_instr_uses_all ipiu,

       iby_ext_bank_accounts ieb,

       iby_external_payers_all iep,

       ce_bank_branches_v cb

 WHERE ieb.ext_bank_account_id = ipiu.instrument_id

   AND ipiu.ext_pmt_party_id   = iep.ext_payer_id

   AND cb.bank_party_id        = ieb.bank_id

   AND iep.cust_account_id     = :vl_cust_account_id

   AND iep.acct_site_use_id    = :vl_cust_site_use_id;