Inactive pending worker data is being pulled in the OTBI Pending worker report.

I have created a pending worker report using the logical SQL. In pending worker report Rehires are being pulled onto the pending worker report where the candidate record is inactive, with the assignment data from their old job, and not with the information for the current job in which they are currently being hired into. We have added a filter of Assignment status type equal to Active. However report is pulling inactive data of candidate and showing Assignment status type of that inactive record as Active.

I am attaching the Logical SQL for that report.