Operation Details
Description: Search of the Liability Instrument on periodFromDate, periodToDate and amount
Sterotype: nsmulti
SQL 
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.periodFromDate >= :periodFromDate 
  ) 
  AND 
  (
    LiabilityInstrument.periodToDate <= :periodToDate 
  )