| Operation Details |  |
| Description: | Returns the activity IDs based on the hearingID, userName, activityStatus and hearingActivityLink type. |
| Sterotype: | ns |
| SQL | |
SELECT HearingActivityLink.activityID INTO :activityID FROM HearingActivityLink, Activity WHERE hearingID = :hearingID AND typeCode = :typeCode AND recordStatusCode = :recordStatus AND userName = :userName AND HearingActivityLink.activityID = Activity.activityID |