Operation Details
Description: Method to return a list of household relationships for a specified participant and caseEvidenceGroupID
Sterotype: nsmulti
SQL 
SELECT
  ConcernRoleRelationship.concernRoleID,
  ConcernRoleRelationship.concernRoleType,
  ConcernRoleRelationship.relConcernRoleID,
  ConcernRoleRelationship.relConcernRoleType,
  ConcernRoleRelationship.relationshipType,
  ISHholdRshipEvidence.nonParentCaretakerRelInd,
  ISHholdRshipEvidence.recipISHholdRshipEvidenceID,
  ConcernRoleRelationship.statusCode,
  ISHholdRshipEvidence.isHholdRshipEvidenceID,
  ISHholdRshipEvidence.participantRoleRshipID
INTO
  :participantRoleID,
  :participantRoleType,
  :relParticipantRoleID,
  :relParticipantRoleType,
  :relationshipType,
  :nonParentCaretakerRelInd,
  :recipISHholdRshipEvidenceID,
  :statusCode,
  :isHholdRshipEvidenceID,
  :participantRoleRshipID 
FROM
  ISHholdRshipEvidence,
  CaseEvidenceGroup,
  CaseEvidenceGroupLink,
  ConcernRoleRelationship 
WHERE CaseEvidenceGroup.caseEvidenceGroupID = :caseEvidenceGroupID 
  AND CaseEvidenceGroup.caseEvidenceGroupID = CaseEvidenceGroupLink.caseEvidenceGroupID 
  AND CaseEvidenceGroupLink.relatedID = ISHholdRshipEvidence.isHholdRshipEvidenceID 
  AND ISHholdRshipEvidence.participantRoleRshipID = ConcernRoleRelationship.concernRoleRelationshipID 
  AND ConcernRoleRelationship.concernRoleID = :participantRoleID 
  AND ConcernRoleRelationship.statusCode = :statusCode