Operation Details
Description:  
Sterotype: nsmulti
SQL
SELECT 
  Obligation.obligationID,
  Obligation.transactionType,
  Obligation.debitCreditType,
  Obligation.amount,
  Obligation.creationDate,
  Obligation.relatedType,
  Obligation.relatedID,
  Obligation.startDate,
  Obligation.endDate,
  Obligation.fundFiscalYearID,
  Obligation.versionNo
INTO 
  :obligationID, 
  :transactionType,
  :debitCreditType,
  :amount,
  :creationDate,
  :relatedType,
  :relatedID,
  :startDate,
  :endDate,
  :fundFiscalYearID,
  :versionNo
FROM 
  Obligation,
  FundFiscalYear, 
  FundLink 
WHERE FundFiscalYear.programFundID = FundLink.programFundID 
  AND FundFiscalYear.fundFiscalYearID = Obligation.fundFiscalYearID 
  AND FundLink.programFundID = :programFundID
  AND Obligation.relatedType = :obligationRelatedType