Operation Details
Description: To retrieve a household budget item record by financial component id.
Sterotype: ns
SQL 
SELECT
  HouseholdBudgetItem.householdBudgetID,
  HouseholdBudgetItem.concernRoleID,
  HouseholdBudgetItem.utilConcernRoleID,
  HouseholdBudgetItem.customerAccName,
  HouseholdBudgetItem.customerAccNumber,
  HouseholdBudgetItem.createdDate,
  HouseholdBudgetItem.startDate,
  HouseholdBudgetItem.endDate,
  HouseholdBudgetItem.rate,
  HouseholdBudgetItem.statusCode,
  HouseholdBudgetItem.comments,
  HouseholdBudgetItem.minimumAmount,
  HouseholdBudgetItem.maximumAmount,
  HouseholdBudgetItem.caseID,
  HouseholdBudgetItem.rulesObjectiveID,
  HouseholdBudgetItem.amount,
  HouseholdBudgetItem.deductionType,
  HouseholdBudgetItem.versionNo
INTO
  :householdBudgetID,
  :concernRoleID,
  :utilConcernRoleID,
  :customerAccName,
  :customerAccNumber,
  :createdDate,
  :startDate,
  :endDate,
  :rate,
  :statusCode,
  :comments,
  :minimumAmount,
  :maximumAmount,
  :caseID,
  :rulesObjectiveID,
  :amount,
  :deductionType,
  :versionNo 
FROM
  HouseholdBudgetItem,
  HouseholdBudgetItemFCLink 
WHERE HouseholdBudgetItemFCLink.financialCompID = :financialCompID 
  AND HouseholdBudgetItem.householdBudgetID = HouseholdBudgetItemFCLink.householdBudgetID