CFR Due date comes blank on AXIS Sync, while there is a Program Office mismatch Request's Primary Office

**Describe the bug in current situation**.

On Production, while Sync'ing EDU-2022-20988 from AXIS, its been found that CFR due date was not Sync'ing and showing blank. But while checking on AXIS UI, under RFD there is a list item with CFR Due on 31-MAR-2022. After investigation with Business Team it been found that Primary Office of this request was earlier CFD and since this PO got moved to EDU, the office with Request level changed, but not at RFD level and at RFD it stayed with CFD. This caused the issue with AXIS Sync Query with FOI FLOW.

Time being, we decided to move Action Office with request/CFD. But code need to be updated to mitigate futuristic issue.

**Link bug to the User Story**

**Impact of this bug**
Minor.

**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. Go to FOI FLOW, to Sync EDU-2022-20988 (Add request user flow...)
2. Click Sync with AXIS Button.
3. On the Pop up, CFR Due Date seems to be NULL. At the same time AXIS lists a due date on RFD.
4. See error - Blank CFR due date.

This request on the PROD will get on the AXIS by moving action offices. But while fixing this issues we need replicate the issue on TEST with the same step - CFD ---> EDUC.

**Actual/ observed behaviour/ results**


**Expected behaviour**
Should display 31-Mar-2022 CFR due from AXIS as shown on the image above. Fix will be like UPDATING the subquery without JOIN on Office and PROGRAM together

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

Start with the AXIS sync query invoked by the FOI FLOW “Sync with AXIS” button and reproduce the CFD-to-EDUC office change in TEST using request EDU-2022-20988. Review the subquery’s Office and Program conditions, then verify that the sync returns the 31-Mar-2022 CFR due date shown in AXIS rather than a blank value.

Written by the indexing model from the issue text.