| Operation Details |  |
| Description: | Retrieves the active unique case ids for the specified concern role id. |
| Sterotype: | nsmulti |
| SQL | |
SELECT DISTINCT caseID INTO :caseID FROM CaseParticipantRole WHERE participantRoleID = :participantRoleID AND recordStatus = :recordStatus |