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, EVIDENCEDESCRIPTOR
WHERE
CURRENTPOSTPONEDVERIFICATION.caseID = :caseID
AND
EVIDENCEDESCRIPTOR.evidenceDescriptorID = CURRENTPOSTPONEDVERIFICATION.evidenceDescriptorID
AND
EVIDENCEDESCRIPTOR.evidenceType = :evidenceType;
|