Operation Details
Description: Reads the bank account details for a concernRoleBankAccountID.
Sterotype: ns
SQL 
SELECT
  BankAccount.bankAccountID,
  bankBranchID,
  name,
  typeCode,
  bankSortCode,
  accountNumber,
  iban,
  bic,
  statusCode,
  startDate,
  endDate,
  comments,
  bankAccountStatus,
  jointAccountInd
INTO
  :bankAccountID,
  :bankBranchID,
  :name,
  :typeCode,
  :bankSortCode,
  :accountNumber,
  :iban,
  :bic,
  :statusCode,
  :startDate,
  :endDate,
  :comments,
  :bankAccountStatus,
  :jointAccountInd 
FROM
  BankAccount,
  ConcernRoleBankAccount 
WHERE ConcernRoleBankAccount.concernRoleBankAccountID = :concernRoleBankAccountID 
  AND BankAccount.bankAccountID = ConcernRoleBankAccount.bankAccountID