Operation Details
Description: Returns the bank account status, start date and record status for a bank account if it is actively being used by a case nominee.
Sterotype: ns
SQL 
SELECT
  BankAccount.bankAccountStatus,
  BankAccount.endDate,
  BankAccount.statusCode
INTO
  :bankAccountStatus,
  :endDate,
  :statusCode 
FROM
  CaseNomineeDestination,
  ConcernRoleBankAccount,
  BankAccount 
WHERE CaseNomineeDestination.caseNomineeID = :caseNomineeID 
  AND CaseNomineeDestination.destinationType = :destinationType 
  AND CaseNomineeDestination.statusCode = :recordStatus 
  AND ConcernRoleBankAccount.concernRoleBankAccountID = CaseNomineeDestination.destinationID 
  AND ConcernRoleBankAccount.bankAccountID = BankAccount.bankAccountID