Operation Details
Description: Method counts active unique concern roles as allegations roles for a case.
Sterotype: ns
SQL 
SELECT
  COUNT (DISTINCT CaseParticipantRole.participantRoleID)
INTO
  :count
FROM
  Allegation,
  AllegationRole,
  CaseParticipantRole
WHERE Allegation.caseID = :caseID
  AND Allegation.recordStatus = :recordStatus
  AND Allegation.allegationID = AllegationRole.allegationID
  AND AllegationRole.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID
  AND CaseParticipantRole.recordStatus = :recordStatus