Operation Details
Description: Retrieves a list of bank account details for the specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  BankAccount.name,
  BankAccount.typeCode,
  BankAccount.bankSortCode,
  BankAccount.bankBranchID,
  BankAccount.accountNumber,
  BankAccount.iban,
  BankAccount.statusCode,
  ConcernRoleBankAccount.concernRoleBankAccountID,
  BankAccount.bankAccountID,
  BankAccount.versionNo
INTO
  :name,
  :typeCode,
  :bankSortCode,
  :bankBranchID,
  :accountNumber,
  :ibanOpt,
  :statusCode,
  :concernRoleBankAccountID,
  :bankAccountID,
  :versionNo 
FROM
  BankAccount,
  ConcernRoleBankAccount 
WHERE concernRoleID = :concernRoleID 
  AND BankAccount.bankAccountID = ConcernRoleBankAccount.bankAccountID