Operation Details
Description: Returns a list of household members for a case who are eligible to receive benefit.
Sterotype: nsmulti
SQL 
SELECT
  ConcernRole.concernRoleName,
  CaseGroups.startDate,
  CaseGroups.endDate
INTO
  :eligibleMemberName,
  :startDate,
  :endDate 
FROM
  CaseGroups,
  ConcernRole 
WHERE CaseGroups.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseGroups.concernRoleID