Operation Details
Description: returns a list of HouseholdBudgetItems which have a status of 'Active', 'Suspended', or 'Pending'
Sterotype: nsmulti
SQL 
SELECT
  HouseholdBudgetItem.householdBudgetID,
  HouseholdBudgetItem.utilConcernRoleID,
  HouseholdBudgetItem.customerAccName,
  HouseholdBudgetItem.caseID,
  HouseholdBudgetItem.rulesObjectiveID,
  HouseholdBudgetItem.amount,
  HouseholdBudgetItem.rate,
  HouseholdBudgetItem.deductionType,
  HouseholdBudgetItem.endDate
INTO
  :householdBudgetID,
  :utilConcernRoleID,
  :customerAccName,
  :caseID,
  :rulesObjectiveID,
  :amount,
  :rate,
  :deductionType,
  :endDate 
FROM
  HouseholdBudgetItem 
WHERE HouseholdBudgetItem.concernRoleID = :concernRoleID 
  AND 
  (
    HouseholdBudgetItem.statusCode = :statusActive 
    OR HouseholdBudgetItem.statusCode = :statusSuspended 
    OR HouseholdBudgetItem.statusCode = :statusPending 
  )