DBA Data[Home] [Help]

APPS.PY_ZA_TAX_REG dependencies on PER_ASSIGNMENTS_F

Line 1436: , per_assignments_f asg

1432: pay_assignment_actions paa
1433: , pay_payroll_actions ppa
1434: , hr_organization_information oit
1435: , per_assignment_extra_info aei
1436: , per_assignments_f asg
1437: , per_people_f pap
1438: , (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id) ptp
1439: WHERE
1440: ppa.payroll_id = p_payroll_id

Line 1468: from per_assignments_f asg2

1464: OR
1465: (
1466: asg.effective_end_date <= ptp.end_date
1467: AND asg.effective_end_date = (select max(asg2.effective_end_date)
1468: from per_assignments_f asg2
1469: where asg2.assignment_id = asg.assignment_id)
1470: )
1471: )
1472: AND asg.payroll_id = p_payroll_id