select
t.process_task_id as task_id,
t.one_line as task_title,
t.description
FROM
pm_process_task t
WHERE
t.process_task_id in ([join $process_task_id ", "])
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)
INSERT INTO pm_process_task_dependency
(dependency_id, task_id, parent_task_id, dependency_type)
VALUES
(:dependency_id, :tsk_id, :parent_tsk_id, :type_id)