Operation Details
Description: Counts duplicate investigation resolution approval check records for an organization unit with no investigation specified.
Sterotype: ns
SQL
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  InvestigationApprovalCheck 
WHERE investigationApprovalCheckID <> :investigationApprovalCheckID 
  AND investigationConfigID IS NULL 
  AND organisationUnitID = :organisationUnitID 
  AND recordStatus = :recordStatus