Operation Details |
Description: | Returns a count of all requests for the specified hearing and requester with the specified status. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :recordCount FROM HearingTranscriptionRequest WHERE hearingID = :hearingID AND requestedByID = :requestedByID AND recordStatusCode = :recordStatusCode |