Operation Details
Description: Searches fund fiscal year details by the fund ID and the obligation period.
Sterotype: nsmulti
SQL 
SELECT 
  FundFiscalYear.fundFiscalYearID, 
  FundFiscalYear.programFundID, 
  FundFiscalYear.fiscalYearID, 
  FundFiscalYear.totalObligatedAmount, 
  FundFiscalYear.comments, 
  FundFiscalYear.status, 
  FundFiscalYear.recordStatus, 
  FundFiscalYear.versionNo 
INTO 
  :fundFiscalYearID, 
  :programFundID, 
  :fiscalYearID, 
  :totalObligatedAmount,  
  :comments, 
  :status, 
  :recordStatus, 
  :versionNo 
FROM 
  FundFiscalYear, 
  FiscalYear 
WHERE FundFiscalYear.programFundID = :programFundID 
  AND FundFiscalYear.fiscalYearID = FiscalYear.fiscalYearID 
  AND :startDate BETWEEN FiscalYear.startDate  AND FiscalYear.endDate 
  AND FundFiscalYear.recordStatus = :recordStatus 
ORDER BY FiscalYear.startDate