CFD and MSD Personal Requests - Showing Up in Incorrect Queues

[KyEggleston]

Describe the bug in current situation
A clear and concise description of what the bug is.

As part of #4352, we gave the ability for personal requests in 'Intake in Progress' or 'Pending Section 5' to be assigned to any IAO team/analyst (previously, these could only be assigned to the Intake team/analysts). While this functionality is working, and these requests can now be assigned to any IAO team/analyst, it appears that these requests, when reassigned, are showing up in the incorrect team queues.

In PROD, when an MSD or CFD personal request is in 'Intake in Progress' or 'Pending Section 5', and has been assigned to another IAO team/analyst that is not the Intake team/analyst, the CFD and MSD personal requests are showing up in every IAO team's 'My Team's Queue', except the Intake team's 'My Team's Queue'.

Link bug to the User Story

#4352

Impact of this bug
Describe the impact, i.e. what the impact is, and number of users impacted.

Chance of Occurring (high/medium/low/very low)

Pre Conditions: which Env, any pre-requesites or assumptions to execute steps?

Steps to Reproduce
Steps to reproduce the behavior:

1. Create an MSD or CFD personal request and move it to 'Intake in Progress' or 'Pending Section 5'
2. Assign the request to the 'Children and Family Team', or an analyst under that team
3. In KC, change your IAO team/group to be the 'Children and Family Team' (ensure this is the only IAO team you are a part of)
4. Log back in to FOI Mod, and review the 'My Team's Queue' - the request should correctly show up in this queue
5. In KC, change your IAO team/group to be the 'Intake' (ensure this is the only IAO team you are a part of)
6. Log back in to FOI Mod, and review the 'My Team's Queue' - the request should not \be displayed in this queue (which is also correct)
7. In KC, change your IAO team/group to be any other IAO team (e.g., 'Resource and Justice Team' (ensure this is the only IAO team you are a part of)
8. Log back in to FOI Mod, and review the 'My Team's Queue' - the request is incorrectly showing up in this queue when it is not assigned to them.

Actual/ observed behaviour/ results

CFD and MSD personal requests, in a request state of 'Intake in Progress' and 'Pending Section 5', when they are reassigned from the Intake team to any other IAO team, the request is incorrectly showing up in all IAO team queues (aside from the Intake team).

Expected behaviour
A clear and concise description of what you expected to happen. Use the gherking language.

GIVEN a request is an MSD or CFD personal request
AND the request is in 'Intake in Progress' or 'Pending Section 5'
WHEN the request is assigned from the Intake team to another IAO team
THEN the request will not show up in the Intake team queue any more
AND the request will show up in the assigned IAO team's 'My Team's Request' queue
AND the request will not show up on any other IAO team's 'My Team's Request' queue

Screenshots/ Visual Reference/ Source
If applicable, add screenshots to help explain your problem. You an use screengrab.