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
|