Operation Details
Description: This method is used to get the household budget items associated with a component. This is used during the generation of FC's.
Sterotype: nsmulti
SQL 
SELECT
  householdBudgetID,
  concernRoleID,
  utilConcernRoleID,
  customerAccName,
  customerAccNumber,
  createdDate,
  startDate,
  endDate,
  rate,
  statusCode,
  comments,
  minimumAmount,
  maximumAmount,
  caseID,
  rulesObjectiveID,
  amount,
  deductionType,
  versionNo
INTO
  :householdBudgetID,
  :concernRoleID,
  :utilConcernRoleID,
  :customerAccName,
  :customerAccNumber,
  :createdDate,
  :startDate,
  :endDate,
  :rate,
  :statusCode,
  :comments,
  :minimumAmount,
  :maximumAmount,
  :caseID,
  :rulesObjectiveID,
  :amount,
  :deductionType,
  :versionNo 
FROM
  HouseholdBudgetItem 
WHERE rulesObjectiveID = :rulesObjectiveID 
  AND caseID = :caseID 
  AND statusCode = :statusCode 
  AND startDate <= :effectiveDate