Operation Details
Description: Returns the Job subscription for a work queue.
Sterotype: nsmulti
SQL 
SELECT
  workQueueSubscriptionID,
  wqs.subscriberID,
  j.name AS subscriberName,
  wqs.subscriberType,
  wqs.subscriptionDateTime
INTO
  :workQueueSubscriptionID,
  :subscriberID,
  :subscriberName,
  :subscriberType,
  :subscriptionDateTime 
FROM
  WorkQueueSubscription wqs,
  Job j 
WHERE wqs.workQueueID = :workQueueID 
  AND wqs.subscriberType = :subscriberType 
  AND wqs.subscriberID = j.jobID 
  AND j.recordStatus = :recordStatus