Operation Details
Description: Retrieves all the fund fiscal years with the given status and whose end date is before the given processing date.
Sterotype: nsmulti
SQL 
SELECT
  FundFiscalYear.fiscalYearID,
  FundFiscalYear.fundFiscalYearID,
  FundFiscalYear.programFundID,
  FundFiscalYear.recordStatus,
  FundFiscalYear.totalObligatedAmount,
  FundFiscalYear.versionNo,
  FundFiscalYear.status,
  FundFiscalYear.comments
INTO
  :fiscalYearID,
  :fundFiscalYearID,
  :programFundID,
  :recordStatus,
  :totalObligatedAmount,
  :versionNo,
  :status,
  :comments 
FROM
  FundFiscalYear,
  FiscalYear 
WHERE FundFiscalYear.fiscalYearID =FiscalYear.fiscalYearID 
  AND FiscalYear.endDate < :businessProcessingDate
  AND FundFiscalYear.status = :status