Operation Details
Description: A Method that will return the details of the household relationship evidence.
Sterotype: ns
SQL 
SELECT
  ConcernRoleRelationship.concernRoleID,
  ConcernRoleRelationship.concernRoleType,
  ConcernRoleRelationship.relConcernRoleID,
  ConcernRoleRelationship.relConcernRoleType,
  ConcernRoleRelationship.relationshipType,
  ISHholdRshipEvidence.isHholdRshipEvidenceID,
  ISHholdRshipEvidence.recipISHholdRshipEvidenceID,
  ISHholdRshipEvidence.nonParentCaretakerRelInd,
  ISHholdRshipEvidence.participantRoleRshipID,
  ConcernRoleRelationship.statusCode
INTO
  :participantRoleID,
  :participantRoleType,
  :relParticipantRoleID,
  :relParticipantRoleType,
  :relationshipType,
  :isHholdRshipEvidenceID,
  :recipISHholdRshipEvidenceID,
  :nonParentCaretakerRelInd,
  :participantRoleRshipID,
  :statusCode 
FROM
  ISHholdRshipEvidence,
  ConcernRoleRelationship 
WHERE ISHholdRshipEvidence.isHholdRshipEvidenceID = :isHholdRshipEvidenceID 
  AND ISHholdRshipEvidence.participantRoleRshipID = ConcernRoleRelationship.concernRoleRelationshipID