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