DELETE FROM
pm_task_assignment
WHERE
task_id = :task_item_id
DELETE FROM
pm_task_assignment
WHERE
task_id = :task_item_id and
party_id = :party_id
SELECT
party_id
FROM
pm_task_assignment
WHERE
task_id = :task_item_id and
party_id = :party_id
LIMIT 1
select
package_id
from
acs_objects
where
object_id =:project_item_id
update
pm_tasks
set
task_number = 1,
status = 1
where
task_id = :new_task_id
select
earliest_start,
earliest_finish,
latest_start,
latest_finish
from
pm_tasks_revisions
where
task_revision_id = :task_revision_id
update
pm_tasks_revisions
set
earliest_start = :earliest_start,
earliest_finish = :earliest_finish,
latest_start = :latest_start,
latest_finish = :latest_finish
where
task_revision_id = :new_task_revision_id