DBA Data[Home] [Help]

APPS.PAY_ZA_SOE dependencies on PER_ALL_ASSIGNMENTS_F

Line 172: ,per_all_assignments_f asg

168: ,peo.per_information1 as COL14 -- Tax Reference Number
169: ,pay_za_soe.get_tax_status(asg.assignment_id, :effective_date) as COL15
170: ,ptp.period_num as COL16
171: From per_all_people_f peo
172: ,per_all_assignments_f asg
173: ,per_jobs_vl job
174: ,pay_assignment_actions paa
175: ,per_assignment_extra_info pae
176: ,per_periods_of_service pps

Line 522: ,per_all_assignments_f asg

518: From pay_balance_types pbt
519: ,pay_balance_dimensions pbd
520: ,pay_assignment_actions paa
521: ,pay_payroll_actions ppa
522: ,per_all_assignments_f asg
523: ,hr_organization_information org
524: Where paa.assignment_action_id = p_assignment_action_id and
525: paa.assignment_id = asg.assignment_id and
526: paa.payroll_action_id = ppa.payroll_action_id and