Operation Details
Description: This method retrieves the fiscal year record for the given fundID and effective date. We expect only one fiscal year to be active for a fund at any given time.
Sterotype: ns
SQL 
SELECT
  FundFiscalYear.fundFiscalYearID,
  FundFiscalYear.programFundID,
  FundFiscalYear.fiscalYearID,
  FundFiscalYear.totalObligatedAmount,
  FundFiscalYear.recordStatus,
  FundFiscalYear.versionNo
INTO
  :fundFiscalYearID,
  :programFundID,
  :fiscalYearID,
  :totalObligatedAmount,
  :recordStatus,
  :versionNo 
FROM
  FundFiscalYear,
  FiscalYear 
WHERE FundFiscalYear.programFundID = :programFundID 
  AND FundFiscalYear.fiscalYearID =FiscalYear.fiscalYearID 
  AND FiscalYear.startDate <= :effectiveDate 
  AND 
  (
    FiscalYear.endDate >= :effectiveDate 
    OR FiscalYear.endDate IS NULL 
  ) 
  AND FundFiscalYear.recordStatus = 'RST1'