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 FC
WHERE FC.categoryCode = :categoryCode
AND FC.statusCode = :statusCode
AND FC.nomineeDelivMethod = :nomineeDelivMethod
AND FC.nextProcessingDate <= :nextProcessingDate
ORDER BY caseID
|