Operation Details
Description: Returns a list of work queues for the current user.
Sterotype: nsmulti
SQL
SELECT
  name,
  workQueueID
INTO
  :name,
  :workQueueID 
FROM
  WORKQUEUE
WHERE 
  allowUserSubscriptionInd = '1'
  AND upper(name) LIKE :workQueueName
  AND workQueueID NOT IN 
  (
    SELECT DISTINCT workQueueID 
    FROM WORKQUEUESUBSCRIPTION
    WHERE subscriberType = 'RL9'
    AND userName = :userName
  )