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.liabInstrumentID = :LiabilityRefNo 
    ) 
    AND 
    (
      LiabilityInstrument.periodFromDate >= :periodFromDate 
    ) 
    AND 
    (
      LiabilityInstrument.periodToDate <= :periodToDate 
  )