Operation Details
Description: Search of the Liability Instrument on the provided search criteria. Search is performed by partial match concern role name.
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 
  (
    UPPER(LiabilityInstrument.concernRoleName) LIKE :concernRoleName 
    OR :concernRoleName IS NULL 
  ) 
  AND  
  (
    LiabilityInstrument.amount = :amount 
    OR :amount = 0
  )
  AND 
  (
    LiabilityInstrument.liabInstrumentID = :lbyExternalRefNo 
    OR :lbyExternalRefNoIsNull <> '0'
  ) 
  AND 
  (
    
    (
      LiabilityInstrument.effectiveDate = :effectiveDate 
      OR :effectiveDate IS NULL 
    ) 
    AND 
    (
      LiabilityInstrument.periodFromDate >= :periodFromDate 
      OR :periodFromDate IS NULL 
    ) 
    AND 
    (
      LiabilityInstrument.periodToDate <= :periodToDate 
      OR :periodToDate IS NULL 
    ) 
  )