Operation Details
Description: To get a list of financial component records that match the specified caseID, financial status code and nomineeDeliveryMethod, and do not match the specified case status codes, and whose processing date are less than or equal the specified processingDateTo.
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 statusCode = :statusCode 
  AND nomineeDelivMethod = :nomineeDelivMethod 
  AND nextProcessingDate <= :processingDateTo 
  AND 
  (
    caseID = 
    ( 
    SELECT
      caseID 
    FROM
      CaseHeader 
    WHERE caseID = :caseID 
      AND statusCode <> :caseStatusCode1 
      AND statusCode <> :caseStatusCode2 
    ) 
  ) 
ORDER BY startDate DESC