SELECT
CURRENTPOSTPONEDVERIFICATION.currentPostponedVerificationID,
CURRENTPOSTPONEDVERIFICATION.evidenceDescriptorID,
CURRENTPOSTPONEDVERIFICATION.caseID,
CURRENTPOSTPONEDVERIFICATION.postponedOn,
CURRENTPOSTPONEDVERIFICATION.postponedByUser,
CURRENTPOSTPONEDVERIFICATION.createdBy,
CURRENTPOSTPONEDVERIFICATION.createdOn,
CURRENTPOSTPONEDVERIFICATION.lastUpdatedBy,
CURRENTPOSTPONEDVERIFICATION.lastUpdatedOn
INTO
:currentPostponedVerificationID,
:evidenceDescriptorID,
:caseID,
:postponedOn,
:postponedByUser,
:createdBy,
:createdOn,
:lastUpdatedBy,
:lastUpdatedOn
FROM
CURRENTPOSTPONEDVERIFICATION, CASEHEADER
WHERE
CURRENTPOSTPONEDVERIFICATION.caseID = CASEHEADER.caseID
AND
CASEHEADER.caseTypeCode = :caseTypeCode;
|