Operation Details
Description: Get the number of outstanding verifications for a given case where the evidence status is ACTIVE and INEDIT.
Sterotype: ns
SQL 
SELECT 
	count(verificationID) 
INTO 
	:recordCount 
FROM 
	verification,  
	VDIEDLink, 
	evidencedescriptor 
WHERE 
	Verification.verificationLinkedID = :caseID 
	AND 
	verificationStatus = :verificationStatus 
	AND 
	verification.VDIEDLinkID = VDIEDLink.VDIEDLinkID 
	AND 
	VDIEDLink.evidenceDescriptorID = evidencedescriptor.evidenceDescriptorID 
	AND 
      (evidencedescriptor.statusCode = :evidenceActiveStatus OR   evidencedescriptor.statusCode = :evidenceInEditStatus)