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