Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  reassessmentBalanceInfoID,
  reassessmentAmount,
  prevBalanceInfoID,
  reassessmentDate,
  amountType,
  coverPeriodFrom,
  coverPeriodTo,
  reassessedBalance,
  caseNomineeID,
  replacementPmtInd
INTO
  :reassessmentBalanceInfoID,
  :reassessmentAmount,
  :prevBalanceInfoID,
  :reassessmentDate,
  :amountType,
  :coverPeriodFrom,
  :coverPeriodTo,
  :reassessedBalance,
  :caseNomineeID,
  :replacementPmtInd 
FROM
  ReassessmentBalanceInfo 
WHERE caseNomineeID = :caseNomineeID 
  AND replacementPmtInd = :replacementPmtInd 
  AND coverPeriodFrom <= :coverPeriodTo 
  AND coverPeriodTo >= :coverPeriodFrom