Operation Details
Description: Method for reading foster care evidence and the participantRoleID of the foster child.
Sterotype: ns
SQL 
SELECT
  FosterCare.evidenceID,
  FosterCare.caseParticipantRoleID,
  FosterCare.parCaseParticipantRoleID,
  FosterCare.expectedEndDate,
  FosterCare.inclInAppInd,
  FosterCare.comments,
  FosterCare.versionNo,
  CaseParticipantRole.participantRoleID
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :parCaseParticipantRoleID,
  :expectedEndDate,
  :inclInAppInd,
  :comments,
  :versionNo,
  :participantRoleID 
FROM
  FosterCare,
  CaseParticipantRole 
WHERE FosterCare.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = FosterCare.caseParticipantRoleID