Operation Details
Description: To get a list of financial component records that match the specified caseID, status code and nomineeDeliveryMethod and whose processing date are less than or equal the specified processingDateTo and greater than or equal the specified processingDateFrom.
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 
WHERE caseID = :caseID 
  AND statusCode = :statusCode 
  AND nomineeDelivMethod = :nomineeDelivMethod 
  AND nextProcessingDate >= :processingDateFrom 
  AND nextProcessingDate <= :processingDateTo 
ORDER BY startDate DESC