select
t.process_task_id as task_id,
t.one_line as task_title,
t.description,
d.parent_task_id
FROM
pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id
WHERE
t.process_task_id in ([join $use_dependency ", "])
select
short_name,
description
FROM
pm_task_dependency_types
ORDER BY
short_name
select
process_task_id as task_id,
one_line as task_title
FROM
pm_process_task
WHERE
process_id = :process_id
ORDER BY
upper(one_line)
DELETE FROM pm_process_task_dependency
WHERE process_task_id = :tsk_id
INSERT INTO pm_process_task_dependency
(dependency_id, process_task_id, parent_task_id, dependency_type)
VALUES
(:dependency_id, :tsk_id, :parent_tsk_id, :type_id)