Operation Details
Description: To retrieve all the FCs on a case which are live during the cover period, i.e. they start before the cover period and end after it.
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 startDate <= :toDate 
  AND 
   (endDate >= :fromDate 
     OR endDate is null)
ORDER BY startDate DESC