Operation Details
Description: Returns the activityIDs for the given hearing that have the given user name.
Sterotype: nsmulti
SQL 
SELECT
  HearingActivityLink.activityID,
  versionNo
INTO
  :activityID,
  :versionNo 
FROM
  HearingActivityLink,
  Activity 
WHERE HearingActivityLink.hearingID = :hearingID 
  AND Activity.activityID = HearingActivityLink.activityID 
  AND userName = :userName