Operation Details
Description: Read all records from the BankAccount table for a particular Organization. This method has a Pre Data Access function that checks if the input Organization key is valid. If invalid this function throws an exception.
Sterotype: nsmulti
SQL 
SELECT
  BankAccount.bankAccountID,
  BankAccount.bankBranchID,
  BankAccount.name,
  BankAccount.typeCode,
  BankAccount.bankSortCode,
  BankAccount.accountNumber,
  BankAccount.statusCode,
  BankAccount.iban,
  BankAccount.versionNo
INTO
  :bankAccountID,
  :bankBranchID,
  :name,
  :typeCode,
  :bankSortCode,
  :accountNumber,
  :statusCode,
  :ibanOpt,
  :versionNo 
FROM
  BankAccount,
  OrgBankAccountLink 
WHERE OrgBankAccountLink.organisationID = :organisationID 
  AND OrgBankAccountLink.bankAccountID = BankAccount.bankAccountID 
ORDER BY bankSortCode