Database SQL Operation: ISHouseholdEvidence.readByCaseEvidenceGroupIDAndParticipantRoleID
Description: | Method to read the dependent child household evidence details |
Sterotype: | ns |
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
|