Operation Details
Description: This method searches for all financial component records for a given case id, case nominee id, status code and with next processing date on or before the given 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 
WHERE caseID = :caseID 
  AND statusCode = :statusCode 
  AND caseNomineeID = :caseNomineeID 
  AND nextProcessingDate <= :nextProcessingDate