Operation Details
Description: Method for reading ownership resource evidence and the partcipantRoleID of the owner.
Sterotype: ns
SQL 
SELECT
  OWNERSHIP.EVIDENCEID,
  OWNERSHIP.CASEPARTICIPANTROLEID,
  OWNERSHIP.VERSIONNO,
  OWNERSHIP.PERCENTAGEOWNED,
  OWNERSHIP.COMMENTS,
  OWNERSHIP.STARTDATE,
  OWNERSHIP.ENDDATE,
  CaseParticipantRole.participantRoleID
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :versionNo,
  :percentageOwned,
  :comments,
  :startDate,
  :endDate,
  :participantRoleID 
FROM
  OWNERSHIP,
  CaseParticipantRole 
WHERE OWNERSHIP.EVIDENCEID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = OWNERSHIP.CASEPARTICIPANTROLEID