Operation Details
Description: Reads ownership details for a Self Employment evidence
Sterotype: ns
SQL 
SELECT
  SelfEmployment.caseParticipantRoleID,
  SelfEmployment.ownershipType,
  ConcernRole.concernRoleName,
  CaseParticipantRole.participantRoleID
INTO
  :ownerCaseParticipantRoleID,
  :ownershipType,
  :ownerName,
  :participantRoleID 
FROM
  SelfEmployment,
  CaseParticipantRole,
  ConcernRole 
WHERE SelfEmployment.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = SelfEmployment.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID