Operation Details
Description: This method searches verification requirements by verifiable data item, related data item type and dates.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT(VerificationRequirementUsage.verificationRequirementID)
INTO
  :verificationRequirementID 
FROM
  VerificationRequirementUsage VerificationRequirementUsage,
  VerificationRequirement VerificationRequirement 
WHERE VerificationRequirement.verifiableDataItemID = :verifiableDataItemID 
  AND VerificationRequirement.fromDate <= :date 
  AND 
  (
    VerificationRequirement.toDate IS NULL 
    OR VerificationRequirement.toDate >= :date 
  ) 
  AND VerificationRequirement.recordStatus <> :recordStatus 
  AND VerificationRequirementUsage.verificationRequirementID = VerificationRequirement.verificationRequirementID 
  AND VerificationRequirementUsage.recordStatus <> :recordStatus 
  AND VerificationRequirementUsage.relatedItemType = :relatedItemType 
  AND VerificationRequirementUsage.relatedItemID = :relatedItemID