Operation Details
Description: Returns a list of active concern role bank accounts for the specified Nominee.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleBankAccount.concernRoleBankAccountID
INTO
  :concernRoleBankAccountID 
FROM
  CaseNominee,
  CaseParticipantRole,
  ConcernRoleBankAccount,
  BankAccount 
WHERE CaseNominee.caseNomineeID = :caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND ConcernRoleBankAccount.concernRoleID = CaseParticipantRole.participantRoleID 
  AND BankAccount.bankAccountID = ConcernRoleBankAccount.bankAccountID 
  AND BankAccount.statusCode = :statusCode 
  AND BankAccount.bankAccountStatus = :bankAccountStatusCode 
  AND BankAccount.endDate IS NULL