Operation Details
Description: Reads CaseParticipantRole details and userName from ParticipantRole.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  CaseParticipantRole.caseID,
  CaseParticipantRole.typeCode,
  CaseParticipantRole.fromDate,
  CaseParticipantRole.toDate,
  CaseParticipantRole.recordStatus,
  CaseParticipantRole.versionNo,
  ConcernRole.concernRoleName
INTO
  :caseParticipantRoleID,
  :participantRoleID,
  :caseID,
  :typeCode,
  :fromDate,
  :toDate,
  :recordStatus,
  :versionNo,
  :name 
FROM
  CaseParticipantRole,
  ConcernRole 
WHERE CaseParticipantRole.caseParticipantRoleID = :caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID