DBA Data[Home] [Help]

APPS.PY_ZA_TAX_REG dependencies on PER_ASSIGNMENTS_F

Line 1518: , per_assignments_f asg

1514: pay_assignment_actions paa
1515: , pay_payroll_actions ppa
1516: , hr_organization_information oit
1517: , per_assignment_extra_info aei
1518: , per_assignments_f asg
1519: , per_people_f pap
1520: , (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id) ptp
1521: WHERE
1522: ppa.payroll_id = p_payroll_id

Line 1550: from per_assignments_f asg2

1546: OR
1547: (
1548: asg.effective_end_date <= ptp.end_date
1549: AND asg.effective_end_date = (select max(asg2.effective_end_date)
1550: from per_assignments_f asg2
1551: where asg2.assignment_id = asg.assignment_id)
1552: )
1553: )
1554: AND asg.payroll_id = p_payroll_id

Line 2221: , per_assignments_f asg

2217: pay_assignment_actions paa
2218: , pay_payroll_actions ppa
2219: , hr_organization_information oit
2220: , per_assignment_extra_info aei
2221: , per_assignments_f asg
2222: , per_people_f pap
2223: , (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id) ptp
2224: WHERE
2225: ppa.payroll_id = p_payroll_id

Line 2255: from per_assignments_f asg2

2251: OR
2252: (
2253: asg.effective_end_date <= ptp.end_date
2254: AND asg.effective_end_date = (select max(asg2.effective_end_date)
2255: from per_assignments_f asg2
2256: where asg2.assignment_id = asg.assignment_id)
2257: )
2258: )
2259: AND asg.payroll_id = p_payroll_id