Operation Details
Description: Returns a list of household budget items and the case reference number.
Sterotype: nsmulti
SQL 
SELECT
  H.caseID,
  CH.caseReference,
  H.amount,
  H.startDate,
  H.endDate,
  H.rulesObjectiveID,
  H.statusCode
INTO
  :caseID,
  :caseReference,
  :amount,
  :startDate,
  :endDate,
  :rulesObjectiveID,
  :statusCode 
FROM
  HouseholdBudgetItem H,
  CaseHeader CH 
WHERE H.caseID = :caseID 
  AND CH.caseID = H.caseID