SELECT
LiabilityInstrument.liabInstrumentID,
LiabilityInstrument.liabInstructionID,
LiabilityInstrument.creationDate,
LiabilityInstrument.amount,
LiabilityInstrument.periodFromDate,
LiabilityInstrument.periodToDate,
LiabilityInstrument.effectiveDate,
LiabilityInstrument.concernRoleID,
LiabilityInstrument.concernRoleName,
LiabilityInstrument.caseNomineeID,
LiabilityInstrument.nomineeName,
LiabilityInstrument.nomineeAlternateID,
LiabilityInstrument.addressID,
LiabilityInstrument.currencyTypeCode,
LiabilityInstrument.currencyExchangeID,
LiabilityInstruction.finInstructionID
INTO
:liabInstrumentID,
:liabInstructionID,
:creationDate,
:amount,
:periodFromDate,
:periodToDate,
:effectiveDate,
:concernRoleID,
:concernRoleName,
:caseNomineeID,
:nomineeName,
:nomineeAlternateID,
:addressID,
:currencyTypeCode,
:currencyExchangeID,
:finInstructionID
FROM
LiabilityInstrument,
LiabilityInstruction
WHERE LiabilityInstrument.liabInstructionID = LiabilityInstruction.liabInstructionID
AND
(
LiabilityInstrument.amount = :amount
)
AND
(
LiabilityInstrument.effectiveDate = :effectiveDate
)
AND
(
LiabilityInstrument.periodFromDate >= :periodFromDate
)
AND
(
LiabilityInstrument.periodToDate <= :periodToDate
)
|