Payment Document and Payment Profile Link

SELECT pd.payment_document_id
     , pd.payment_document_name
     , ba.bank_account_name
     , app.payment_profile_id
     , app.payment_profile_name
  FROM ce_payment_documents     pd
     , iby_sys_pmt_profiles_b   spp
     , iby_acct_pmt_profiles_vl app
     , iby_formats_b            fmt
     , ce_bank_accounts         ba
 WHERE pd.format_code              = spp.payment_format_code
   AND spp.system_profile_code     = app.system_profile_code
   AND fmt.format_code             = spp.payment_format_code
   AND fmt.format_type_code        = 'OUTBOUND_PAYMENT_INSTRUCTION'
   AND pd.internal_bank_account_id = ba.bank_account_id
 ORDER BY 1,4