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 <= :processingDateTo
ORDER BY startDate DESC
|