| Operation Details |  |
| Description: | Checks if an approval check already exists for an investigation. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :numberOfRecords FROM InvestigationApprovalCheck WHERE investigationApprovalCheckID <> :investigationApprovalCheckID AND investigationConfigID = :investigationConfigID AND typeCode = :typeCode AND recordStatus = :recordStatus |