179: AND hroinf.org_information1 = 'HR_LEGAL'
180: AND hroinf.org_information2 = 'Y'
181: AND EXISTS
182: ( SELECT 1
183: FROM per_assignments_f perasg ,
184: pay_assignment_actions pyaact,
185: pay_pre_payments prepay -- Moved from outer query to subquery
186: WHERE pyaact.payroll_action_id = ppa.payroll_action_id
187: -- join now to outer query