Operation Details
Description: Reads nominated representative's details for a service plan delivery.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  CaseParticipantRole.fromDate,
  CaseParticipantRole.toDate,
  CaseParticipantRole.typeCode,
  CaseParticipantRole.recordStatus,
  CaseParticipantRole.comments,
  CaseParticipantRole.versionNo,
  ConcernRole.concernRoleName
INTO
  :caseParticipantRoleID,
  :participantRoleID,
  :fromDate,
  :toDate,
  :typeCode,
  :recordStatus,
  :comments,
  :versionNo,
  :fullName 
FROM
  CaseParticipantRole,
  ConcernRole 
WHERE CaseParticipantRole.caseParticipantRoleID = :caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID