Operation Details
Description: This method will count the Accounts for a particular Bank Branch. accountStatusCode will be the input attribute, This will decide what kind of records to be retrieved from the database i.e. either Active or Canceled
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :activeAccounts 
FROM
  BankAccount 
WHERE BankAccount.bankBranchID = :bankBranchID 
  AND BankAccount.statusCode = :activeStatusCode