Operation Details
Description: Search of the Liability Instrument on ConcernRoleName, LbyExternalRefNo and a combination of other search criteria.
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.concernRoleName = :concernRoleName 
  ) 
  AND 
  (
    LiabilityInstrument.liabInstrumentID = :lbyExternalRefNo 
  ) 
  AND 
  (
    
    (
      LiabilityInstrument.effectiveDate = :effectiveDate 
      OR :effectiveDate IS NULL 
    ) 
    AND 
    (
      LiabilityInstrument.periodFromDate >= :periodFromDate 
      OR :periodFromDate IS NULL 
    ) 
    AND 
    (
      LiabilityInstrument.periodToDate <= :periodToDate 
      OR :periodToDate IS NULL 
    ) 
  )