Operation Details
Description: Return the number of cases for which the bank account is used for nominee payment.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  CaseNomineeDestination,
  CaseParticipantRole,
  CaseNominee 
WHERE CaseNomineeDestination.destinationID = :concernRoleBankAccountID 
  AND CaseNomineeDestination.destinationType = :destinationType 
  AND CaseNomineeDestination.statusCode = :statusCode 
  AND CaseNominee.caseNomineeID = CaseNomineeDestination.caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = :participantRoleID