Operation Details
Description: Returns the concern full name and participant role id by case participant role id.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.participantRoleID,
  ConcernRole.concernRoleName
INTO
  :participantRoleID,
  :name 
FROM
  CaseParticipantRole,
  ConcernRole 
WHERE CaseParticipantRole.caseParticipantRoleID = :caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID