Operation Details
Description: Retrieves a list of Bank Account Snapshot details for the specified ConcernRole Bank Account record.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleBankAccountSnapshot.concernRoleBnkAccSnapshotID,
  BankAccount.name,
  BankAccount.typeCode,
  BankBranch.name,
  BankAccount.accountNumber,
  BankAccount.iban,
  BankAccount.statusCode,
  ConcernRoleBankAccountSnapshot.creationDateTime,
  ConcernRoleBankAccountSnapshot.bankAccountID
INTO
  :concernRoleBnkAccSnapshotID,
  :name,
  :typeCode,
  :branchName,
  :accountNumber,
  :ibanOpt,
  :statusCode,
  :creationDateTime,
  :bankAccountID 
FROM
  BankAccount,
  ConcernRoleBankAccountSnapshot,
  BankBranch 
WHERE ConcernRoleBankAccountSnapshot.concernRoleBankAccountID = :concernRoleBankAccountID 
  AND BankAccount.bankAccountID = ConcernRoleBankAccountSnapshot.bankAccountID 
  AND BankAccount.bankBranchID = BankBranch.bankBranchID 
ORDER BY creationDateTime DESC