Query - Converting SQL criteria for max effdt to PS QUERY

 I created an Oracle SQL that gets the information that I need.  There is one criteria within the SQL that I am having trouble re-creating in PS Query.  Any suggestions would be greatly appreciated. The criteria is

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)