Operation Details |
Description: | To retrieve the earliest financial component start date by caseID, componentType and Status |
Sterotype: | ns |
SQL |
SELECT MIN(startDate) INTO :startDate FROM FinancialComponent WHERE caseID = :caseID AND typeCode = :typeCode AND statusCode = :statusCode |