| Operation Details |  |
| Description: | Returns the earliest deadline date from the all of the active and approved AppealRelationship records for an appeal case. |
| Sterotype: | ns |
| SQL | |
SELECT MIN(deadlineDate) INTO :deadlineDate FROM AppealRelationship WHERE appealCaseID = :appealCaseID AND statusCode = :statusCode AND recordStatus = :recordStatus |