I created an Oracle SQL that extracts the information that I need. I want to convert the SQL to a PS Query. I do not know how to replicate the following criteria in PS Query. Any suggestions would be greatly appreciated.

and j.effdt =
(select max(j1.effdt)
from ps_job j1
where j1.emplid = j.emplid
and j1.empl_rcd = j.empl_rcd
and ((j1.action = 'AAA' and j1.action_reason = 'BBB')
or (j1.action = 'CCC' and j1.action_reason = 'DDD'))
and j1.effdt <= sysdate)