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.caseID = :caseID
AND FC.categoryCode = :categoryCode
AND FC.statusCode = :statusCode
AND FC.caseNomineeID = :caseNomineeID
AND FC.nextProcessingDate <= :nextProcessingDate
|