Operation Details
Description: Returns the name, case participant role ID and participant role ID based on the case ID and participant role type.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRole.concernRoleName,
  ConcernRole.primaryAlternateID,
  CaseParticipantRole.participantRoleID,
  CaseParticipantRole.caseParticipantRoleID
INTO
  :name,
  :alternateID,
  :participantRoleID,
  :caseParticipantRoleID 
FROM
  ConcernRole,
  CaseParticipantRole 
WHERE CaseParticipantRole.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  AND CaseParticipantRole.typeCode = :typeCode