| Operation Details |  |
| Description: | Counts the activities based on the hearingID, userName, activityStatus and hearingActivityLinkType. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :numberOfRecords FROM HearingActivityLink, Activity WHERE HearingActivityLink.hearingID = :hearingID AND typeCode = :typeCode AND Activity.activityID = HearingActivityLink.activityID AND recordStatusCode = :recordStatus AND userName = :userName |