Well you posted the DDL for a table called ProcedureCode, but not one for ProcedureMaster, which is referenced in the update.

If this is a true Parent Child Hierarchy, I would expect the row where ProcedureId=86 to have a NULL ParentProcedureId as this would be classed as the root node, so it cant be the parent of itself.