Operation Details |
Description: | Retrieve the latest CREOLE Program Recommendation ID |
Sterotype: | ns |
SQL |
SELECT creoleProgramRecommendationID INTO :creoleProgramRecommendationID FROM CREOLEProgramRecommendation WHERE caseID=:caseID AND dateTime = ( SELECT MAX(dateTime) FROM CREOLEProgramRecommendation WHERE caseID=:caseID ) |