Operation Details
Description: Method to list active allegation role for specified case id.
Sterotype: nsmulti
SQL 
SELECT DISTINCT
  AllegationRole.roleType,
  ConcernRole.concernRoleID,
  ConcernRole.concernRoleName
INTO
  :allegationRoleType,
  :concernRoleID,
  :concernRoleName
FROM
  Allegation,
  AllegationRole,
  CaseParticipantRole,
  ConcernRole
WHERE Allegation.caseID = :caseID
  AND Allegation.recordStatus = :recordStatus
  AND Allegation.allegationID = AllegationRole.allegationID
  AND AllegationRole.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID
  AND CaseParticipantRole.recordStatus = :recordStatus
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID