Operation Details
Description: Returns the details of the active task redirection or task allocation blocking record, if any, for a specified redirect from user name.
Sterotype: ns
SQL 
SELECT
  t.taskRedirectionID,
  t.toUserName,
  t.blockTaskAllocation,
  t.versionNo,
  t.toRedirectID,
  t.toRedirectType
INTO
  :taskRedirectionID,
  :toUserName,
  :blockTaskAllocation,
  :versionNo,
  :toRedirectID,
  :toRedirectType 
FROM
  TaskRedirection t 
WHERE t.fromUserName = :userName 
  AND :currentDateTime >= t.startDateTime 
  AND 
  (
    t.endDateTime IS NULL 
    OR :currentDateTime < t.endDateTime 
  )