Operation Details
Description: This method reads the Bank Account Status and End Date for a Nominee Bank Account.
Sterotype: ns
SQL 
SELECT
  BankAccount.bankAccountStatus,
  BankAccount.endDate
INTO
  :bankAccountStatus,
  :endDate 
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