SELECT
  t.taskID,
  t.wdoSnapshot,
  t.status,
  w.deadlineTime,
  t.priority,
  t.assignedDateTime,
  t.versionNo
INTO
  :taskID,
  :subject,
  :status,
  :taskDeadlineDateTime,
  :taskPriority,
  :assignedDateTime,
  :versionNo 
FROM
  Task t 
  
  LEFT OUTER JOIN
  
  WorkflowDeadline w 
  ON (t.taskID = w.taskID) 
WHERE t.reservedBy = :relatedName 
  AND t.status NOT IN ( :taskCompleted, :taskClosed)