Operation Details
Description: Returns the concern role name for a case nominee.
Sterotype: ns
SQL 
SELECT
  ConcernRole.concernRoleName
INTO
  :concernRoleName 
FROM
  CaseNominee,
  CaseParticipantRole,
  ConcernRole 
WHERE CaseNominee.caseNomineeID = :caseNomineeID 
  AND CaseNominee.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID