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