Operation Details
Description: Returns a list of waivers for a case
Sterotype: nsmulti
SQL 
SELECT
	VerificationWaiver.verificationWaiverID,
	VerificationWaiver.verificationID,
	VerificationWaiver.VDIEDLinkID,
	VerificationWaiver.startDate,
	VerificationWaiver.endDate,
	VerificationWaiver.comments,
	VerificationWaiver.recordStatus,
	VerificationWaiver.versionNo,
	EvidenceDescriptor.evidenceDescriptorID,
	EvidenceDescriptor.caseID,
	EvidenceDescriptor.participantID
INTO
	:verificationWaiverID,
	:verificationID,
	:VDIEDLinkID,
	:startDate,
	:endDate,
	:comments,
	:recordStatus,
	:versionNo,
	:evidenceDescriptorID,
	:caseID,
	:participantID
FROM
	VerificationWaiver,
	VDIEDLink,
	EvidenceDescriptor
WHERE
	VerificationWaiver.VDIEDLinkID = VDIEDLink.VDIEDLinkID
	AND VDIEDLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID
	AND EvidenceDescriptor.caseID = :caseID