Sergey,

I am incorrect the FOR applies to the Target of the append. That is why FOR NOT DELETED() doesn't work as one might expect as the records in the target are not deleted().