Operation Details
Description: To retrieve all related ISHouseholdComposition records
Sterotype: nsmulti
SQL 
SELECT
  isHouseholdCompositionID,
  isRelHholdCompositionID
INTO
  :isHouseholdCompositionID,
  :isRelHholdCompositionID 
FROM
  ISHholdCompRship 
WHERE ISHholdCompRship.caseID = :caseID 
  AND 
  (
    ISHholdCompRship.isHouseholdCompositionID = :isHouseholdCompositionID 
    OR ISHholdCompRship.isRelHholdCompositionID = :isHouseholdCompositionID 
  )