SELECT
  wqs.workQueueSubscriptionID,
  u.userName,
  u.fullName AS subscriberName,
  wqs.subscriptionDateTime
INTO
  :workQueueSubscriptionID,
  :userName,
  :subscriberName,
  :subscriptionDateTime 
FROM
  WorkQueueSubscription wqs,
  Users u 
WHERE wqs.workQueueID = :workQueueID 
  AND wqs.userName = u.userName 
  AND wqs.subscriberType = :subscriberType 
  AND u.statusCode = :recordStatus