| Operation Details |  |
| Description: | Returns the deadline details of all the active appealed cases of a concrete appeal case. |
| Sterotype: | nsmulti |
| SQL | |
SELECT appealRelationshipID, deadlineDate INTO :appealRelationshipID, :deadlineDate FROM AppealRelationship WHERE appealCaseID = :appealCaseID AND recordStatus = :recordStatus |