Operation Details
Description: To get a list of financial component records that match the specified caseID, status code and whose nextProcessingDate is less than or equal to the input date.
Sterotype: nsmulti
SQL 
SELECT
  financialCompID,
  concernRoleID,
  caseNomineeID,
  caseID,
  primaryClientID,
  categoryCode,
  typeCode,
  startDate,
  endDate,
  creationDate,
  creationTypeCode,
  amount,
  rate,
  maxAmount,
  minAmount,
  statusCode,
  fundID,
  dueDate,
  coverPeriodType,
  coverPeriodOffset,
  nomineeDelivMethod,
  deliveryMethodOffset,
  nextProcessingDate,
  productID,
  adjustmentInd,
  caseTypeCode,
  currencyTypeCode,
  rulesObjectiveID,
  frequency,
  instrumentGenInd,
  expiryDate,
  versionNo,
  inRespectOfID
INTO
  :financialCompID,
  :concernRoleID,
  :caseNomineeID,
  :caseID,
  :primaryClientID,
  :categoryCode,
  :typeCode,
  :startDate,
  :endDate,
  :creationDate,
  :creationTypeCode,
  :amount,
  :rate,
  :maxAmount,
  :minAmount,
  :statusCode,
  :fundID,
  :dueDate,
  :coverPeriodType,
  :coverPeriodOffset,
  :nomineeDelivMethod,
  :deliveryMethodOffset,
  :nextProcessingDate,
  :productID,
  :adjustmentInd,
  :caseTypeCode,
  :currencyTypeCode,
  :rulesObjectiveID,
  :frequency,
  :instrumentGenInd,
  :expiryDate,
  :versionNo,
  :inRespectOfID 
FROM
  FinancialComponent FC 
WHERE FC.caseID = :caseID 
  AND FC.categoryCode = :categoryCode 
  AND FC.statusCode = :statusCode 
  AND FC.nextProcessingDate <= :nextProcessingDate