SELECT
  concernRoleName,
  caseParticipantRoleID,
  primaryAlternateID
INTO
  :name,
  :caseParticipantRoleID,
  :alternateID 
FROM
  ConcernRole,
  CaseParticipantRole 
WHERE CaseParticipantRole.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  AND CaseParticipantRole.typeCode = :typeCode