Operation Details |
Description: | Reads an audit case config record by case type and category. |
Sterotype: | ns |
SQL |
SELECT auditCaseConfigID, caseType, caseCategory, auditAlgorithm, caseAuditTypeSID, manCaseSelectInd, versionNo INTO :auditCaseConfigID, :caseType, :caseCategory, :auditAlgorithm, :caseAuditTypeSID, :manCaseSelectInd, :versionNo FROM AuditCaseConfig WHERE caseType = :caseType AND ( caseCategory = :caseCategory OR caseCategory IS NULL ) |