Operation Details |
Description: | This method returns the maximum percentage and record count of active approval checks configured for an organization unit and any issue. |
Sterotype: | ns |
SQL |
SELECT MAX(percentage), COUNT(*) INTO :percentage, :numRecords FROM IssueResolutionApprovalCheck WHERE organisationUnitID = :organisationUnitID AND typeCode = :typeCode AND recordStatus = :recordStatus |