Operation Details
Description: @deprecated in curam v6 replaced with {@link searchByFromUserNameAndCurrentDateTime}, since the return struct ActiveTaskRedirectionOrTaskAllocationBlockingPeriodDetails has been deprecated. Instead a new method searchByFromUserNameAndCurrentDateTime has been introduced which along with existing functionality retrieves task redirection records of members other than users based on from user name and current time.
Sterotype: ns
SQL 
SELECT
  t.taskRedirectionID,
  t.toUserName,
  t.blockTaskAllocation,
  t.versionNo
INTO
  :taskRedirectionID,
  :toUserName,
  :blockTaskAllocation,
  :versionNo
FROM
  TaskRedirection t 
WHERE t.fromUserName = :userName 
  AND :currentDateTime >= t.startDateTime 
  AND 
  (
    t.endDateTime IS NULL 
    OR :currentDateTime < t.endDateTime 
  )