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 nextProcessingDate <= :processingDateTo
AND
(
caseID =
(
SELECT
caseID
FROM
CaseHeader
WHERE caseID = :caseID
AND statusCode <> :caseStatusCode
)
)
ORDER BY startDate DESC
|