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