Operation Details
Description: Reads an alien sponsor record returning the participant name and the caseParticipantRoleID.
Sterotype: ns
SQL 
SELECT
  AlienSponsor.caseParticipantRoleID,
  ConcernRole.concernRoleName
INTO
  :caseParticipantRoleID,
  :participantName 
FROM
  AlienSponsor,
  CaseParticipantRole,
  ConcernRole 
WHERE AlienSponsor.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = AlienSponsor.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID