Operation Details
Description: Method to read the dependent child household evidence details
Sterotype: ns
SQL
SELECT
  ISHouseholdEvidence.isHouseholdEvidenceID,
  ISHouseholdEvidence.participantRoleID,
  ISHouseholdEvidence.studentInd,
  ISHouseholdEvidence.studentGraduationDate
INTO
  :isHouseholdEvidenceID,
  :participantRoleID,
  :studentInd,
  :studentGraduationDate 
FROM
  ISHouseholdEvidence,
  CaseEvidenceGroup,
  CaseEvidenceGroupLink 
WHERE CaseEvidenceGroup.caseEvidenceGroupID = :evidenceGroupID 
  AND CaseEvidenceGroup.caseEvidenceGroupID = CaseEvidenceGroupLink.caseEvidenceGroupID 
  AND CaseEvidenceGroupLink.relatedID = ISHouseholdEvidence.isHouseholdEvidenceID 
  AND ISHouseholdEvidence.participantRoleID = :participantRoleID