Operation Details
Description: This methods retrieves all the records for the given relatedID and startDate and endDate for the select and evaluate fund operation
Sterotype: nsmulti
SQL 
SELECT
  FundLink.priority,
  FundFiscalYear.fundFiscalYearID,
  FundFiscalYear.totalObligatedAmount,
  FiscalYear.fiscalYearID,
  FundFiscalYear.programFundID
INTO
  :priority,
  :fundFiscalYearID,
  :totalObligatedAmount,
  :fiscalYearID,
  :programFundID 
FROM
  FundLink,
  FundFiscalYear,
  FiscalYear 
WHERE FundLink.relatedID = :relatedID 
  AND FundFiscalYear.programFundID = FundLink.programFundID 
  AND FundFiscalYear.fiscalYearID = FiscalYear.fiscalYearID 
  AND FundLink.startDate <= :startDate 
  AND 
  (
    FundLink.endDate >= :startDate 
    OR FundLink.endDate IS NULL 
  )