Operation Details
Description:  
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 :currentDate BETWEEN FiscalYear.startDate and FiscalYear.endDate 
  AND FundFiscalYear.recordStatus = :recordStatus
ORDER BY FiscalYear.yearName