Operation Details
Description: Returns the organization object subscription to work queue.
Sterotype: nsmulti
SQL
SELECT
  workQueueSubscriptionID,
  wqs.subscriberID,
  ou.name AS subscriberName,
  wqs.subscriberType,
  wqs.subscriptionDateTime
INTO
  :workQueueSubscriptionID,
  :subscriberID,
  :subscriberName,
  :subscriberType,
  :subscriptionDateTime 
FROM
  WorkQueueSubscription wqs,
  OrganisationUnit ou 
WHERE wqs.workQueueID = :workQueueID 
  AND wqs.subscriberType = :subscriberType 
  AND wqs.subscriberID = ou.organisationUnitID 
  AND ou.recordStatus = :recordStatus