Operation Details |
Description: | Reads the maximum effective date for a specified case id and concern role id, which has specified status code . |
Sterotype: | ns |
SQL |
SELECT MAX(effectiveDate) INTO :effectiveDate FROM InstructionLineItem WHERE caseID = :caseID AND concernRoleID = :concernRoleID AND statusCode = :statusCode |