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