3958: and deletion_date is not null
3959: and deletion_approval_date is null;
3960:
3961:
3962: delete from amw_significant_elements
3963: where pk1 = p_process_id
3964: and approval_date is null
3965: and object_type = 'PROCESS';
3966:
3963: where pk1 = p_process_id
3964: and approval_date is null
3965: and object_type = 'PROCESS';
3966:
3967: update amw_significant_elements
3968: set deletion_date = null
3969: where pk1 = p_process_id
3970: and object_type = 'PROCESS'
3971: and deletion_date is not null