SELECT
  DISTINCT(Task_wa.taskID),
  Task_wa.subject,
  Task_wa.dueDateTime,
  Task_wa.status,
  Task_wa.priority,
  Task_wa.reservedBy,
  Task_wa.versionNo
INTO
  :taskID,
  :subject,
  :dueDateTime,
  :status,
  :priority,
  :reservedBy,
  :versionNo 
FROM
  Task_wa,
  TaskLink 
WHERE 
  (
    
    (
      
      (
        TaskLink.linkedID = :concernRoleID 
      ) 
      AND 
      (
        TaskLink.linkType = :linkTypeConcernRole 
      ) 
    ) 
    AND TaskLink.taskID in 
    ( 
    SELECT
      taskID 
    FROM
      TaskLink 
    WHERE TaskLink.linkedID = :caseID 
      AND TaskLink.linkType = :linkTypeCase 
    ) 
  ) 
  AND 
  (
    
    (
      Task_wa.taskID = TaskLink.taskID 
    ) 
    AND 
    (
      
      (
        Task_wa.status <> :status 
      ) 
      OR 
      (
        :status IS NULL 
      ) 
    ) 
  )