SQL query to populate cost center values based on a cost center to agency related value set

Summary:

I am trying to create a table based value set SQL query to populate a task level DFF with cost center values based on a cost center to agency related value set. The agency value should be pulled from the project organization the task is under. Below is my progress so far but I am having issues combining the two. The first query pulls all cost center values from the value set. The second query pulls the agency value needed to be used as a filter criteria. I also need to change the second query to be dynamic and