SELECT
ProductDeliveryCertDiary.caseID,
certificationReceivedDate,
periodFromDate,
periodToDate,
documentRefNumber,
fileRefNumber,
certificationDiaryID,
ProductDeliveryCertDiary.comments,
ProductDeliveryCertDiary.statusCode,
versionNo
INTO
:caseID,
:certificationReceivedDate,
:periodFromDate,
:periodToDate,
:documentRefNumber,
:fileRefNumber,
:certificationDiaryID,
:comments,
:statusCode,
:versionNo
FROM
ProductDeliveryCertDiary
WHERE ProductDeliveryCertDiary.caseID = :caseID
ORDER BY periodFromDate DESC
|