update
pm_process_task
set
process_task_id = :process_task_id,
process_id = :process_id,
one_line = :one_line,
description = :desc,
estimated_hours_work = :work,
estimated_hours_work_min = :work_min,
estimated_hours_work_max = :work_max
select
current_timestamp
FROM
dual
select
t.process_id,
t.one_line as task_title,
t.description,
t.estimated_hours_work,
t.estimated_hours_work_min,
t.estimated_hours_work_max
FROM
pm_process_task t LEFT JOIN pm_process_task_dependency d ON d.process_task_id = t.process_task_id
WHERE
t.process_task_id in ([join $process_task_id ","])
SELECT
p.project_id
FROM
pm_projectsx p, cr_items i
WHERE
p.item_id = :project_item_id and
p.revision_id = i.live_revision