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,
  PlannedItem,
  PlanItem
WHERE 
  PlannedItem.planItemID = PlanItem.planItemID AND 
  Obligation.relatedID = PlannedItem.plannedItemID AND 
  PlanItem.associatedID = :relatedID AND 
  Obligation.relatedType = :relatedType AND 
  Obligation.creationDate >= :startDate AND (Obligation.creationDate   <= :endDate OR :endDate is NULL)