Moved Position still shows in SQL

 Hi

Hopefully I can explain what is happening here.   We have had a recent change to our position structure.  We have 4 large 'departments' which we have to report on.  To do this I have written a bit of sql (I'll put it below) which basically does a connect by, starting with the head position in a specific 'department' - this then allows me to see all the positions within this department.

A group of positions have recently been moved in the position structure from one department to another - however when I run my query with 'connect by' - they are showing up for 2 different departments - which is wrong.