SELECT
ec.autoAppliedDate,
ec.contestedDate,
ec.contestedReason,
ec.evidenceDescriptorID,
ec.initiallyCompatible,
ec.pdmRunCaseControlID,
ec.pdmRunEvidenceControlID,
ec.contestedBy,
ec.versionNo
INTO
:autoAppliedDate,
:contestedDate,
:contestedReason,
:evidenceDescriptorID,
:initiallyCompatible,
:pdmRunCaseControlID,
:pdmRunEvidenceControlID,
:contestedBy,
:versionNo
FROM PDMRunCaseControl cc,
PDMRunEvidenceControl ec,
PDMRunConfig rc
WHERE
cc.caseID = :caseID
AND cc.pdmRunCaseControlID = ec.pdmRunCaseControlID
AND cc.runID = rc.runID
AND rc.annualRenewalInd = :annualRenewalInd
ORDER BY ec.evidenceDescriptorID ASC
|