DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_RUN_RESULTS

Line 190: ,pay_run_results prr

186: ,pay_balance_dimensions pbd
187: -- ,per_periods_of_service pps
188: ,pay_payroll_actions ppa
189: ,pay_assignment_actions pac
190: ,pay_run_results prr
191: WHERE pac.assignment_id = c_assignment_id
192: AND pac.tax_unit_id = c_registered_employer --2610141
193: AND paa.assignment_id = pac.assignment_id
194: AND pac.payroll_action_id = ppa.payroll_Action_id

Line 231: ,pay_run_results prr

227: DISTINCT pet.element_information2 balance_type_id
228: FROM per_all_assignments_f paf
229: ,pay_payroll_actions ppa
230: ,pay_assignment_actions paa
231: ,pay_run_results prr
232: ,pay_element_types_f pet
233: WHERE paa.assignment_id = c_assignment_id
234: AND paf.business_group_id = ppa.business_group_id
235: AND ppa.effective_date BETWEEN c_start_date AND c_end_date