GoldenGate replication filtering

I have a requirement to extract data from one source table and load into 2 target tables based on a data condition

Source tables : S1 and S2  (extract database based on a sub query from S2)

Target Table : T1 & T2 : populate target tables based a column codition

can you help with SQLEXEC function

S1 - Employee table

S2 - Department table

I want to extract data from S1 based on Department Id

select * from S1.employeetable where dept_id = (select dept_id from s2.dept table)