SELECT
DISTINCT(Task_wa.taskID),
Task_wa.reservedBy,
Task_wa.subject,
Task_wa.dueDateTime,
Task_wa.priority,
Task_wa.status,
Task_wa.versionNo
INTO
:taskID,
:reservedBy,
:subject,
:dueDateTime,
:priority,
:status,
:versionNo
FROM
Task_wa,
TaskLink,
CaseHeader,
CaseParticipantRole
WHERE
(
(
(
CaseHeader.integratedCaseID = :caseID
)
AND
(
TaskLink.linkedID = CaseHeader.caseID
)
AND
(
TaskLink.linkType = :linkTypeCase
)
)
OR
(
(
CaseHeader.caseID = :caseID
)
AND
(
TaskLink.linkedID = CaseHeader.caseID
)
AND
(
TaskLink.linkType = :linkTypeCase
)
)
)
AND
(
Task_wa.dueDateTime >= :fromDateTime
)
AND
(
Task_wa.dueDateTime < :toDateTime
)
AND
(
TaskLink.taskID = Task_wa.taskID
)
AND
(
(
Task_wa.status <> :taskStatus
)
OR
(
:taskStatus IS NULL
)
)
ORDER BY Task_wa.taskID
|