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