SELECT
  workQueueSubscriptionID,
  ExternalUser.userName,
  subscriptionDateTime
INTO
  :workQueueSubscriptionID,
  :userName,
  :subscriptionDateTime 
FROM
  WorkQueueSubscription ,
  ExternalUser 
WHERE WorkQueueSubscription.workQueueID = :workQueueID 
  AND WorkQueueSubscription.userName = ExternalUser.userName 
  AND WorkQueueSubscription.subscriberType = 'RL50' 
  AND ExternalUser.statusCode = 'RST1'