Operation Details
Description: This method returns the maximum percentage and record count of active approval checks configured for a user and a particular investigation.
Sterotype: ns
SQL 
SELECT
  MAX(percentage),
  COUNT(*)
INTO
  :percentage,
  :numRecords 
FROM
  InvestigationApprovalCheck 
WHERE userName = :userName 
  AND typeCode = :typeCode 
  AND investigationConfigID = :investigationConfigID 
  AND recordStatus = :recordStatus