DBA Data[Home] [Help]

APPS.PAY_US_NACHA_IAT_TAPE dependencies on PER_ASSIGNMENTS_F

Line 183: FROM per_assignments_f perasg ,

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