eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_ATS_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 66: per_all_assignments_f paa,

62: pai.action_information25 User_Bal_String
63: from
64: pay_assignment_actions assact,
65: pay_action_information pai,
66: per_all_assignments_f paa,
67: per_all_people_f pap,
68: per_periods_of_service ppos,
69: hr_organization_units hou,
70: hr_organization_information hoi

Line 88: FROM per_all_assignments_f asg

84: and pai.effective_date = lp_Tax_Year_End_Date
85: and paa.effective_start_date =
86: (
87: SELECT MIN(asg.effective_start_date)
88: FROM per_all_assignments_f asg
89: WHERE asg.assignment_id = paa.assignment_id
90: and asg.payroll_id is not NULL
91: and asg.effective_start_date <= least(nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date), lp_Tax_Year_End_Date)
92: and nvl(asg.effective_end_date, lp_Tax_Year_End_Date) >= ppos.date_start

Line 165: per_all_assignments_f paa

161: hoi.org_information1 leg_tax_ref
162: from hr_organization_units hou,
163: hr_organization_information hoi,
164: hr_organization_information hoi1,
165: per_all_assignments_f paa
166: where paa.assignment_id = p_assignment_id
167: and hou.organization_id = nvl(paa.establishment_id,-1)
168: and hoi.organization_id = hou.organization_id
169: and hoi1.organization_id = hou.organization_id

Line 179: FROM per_all_assignments_f asg

175: and hoi.org_information2 IS NOT NULL
176: and paa.effective_start_date =
177: (
178: SELECT MIN(asg.effective_start_date)
179: FROM per_all_assignments_f asg
180: WHERE asg.assignment_id = paa.assignment_id
181: and asg.effective_start_date <= p_tax_year_end_date
182: and nvl(asg.effective_end_date, p_tax_year_end_date) >= p_tax_year_start_date
183:

Line 1663: per_all_assignments_f paa,

1659: pai.action_information25 User_Bal_String
1660: from
1661: pay_assignment_actions assact,
1662: pay_action_information pai,
1663: per_all_assignments_f paa,
1664: per_all_people_f pap,
1665: per_periods_of_service ppos,
1666: hr_organization_units hou,
1667: hr_organization_information hoi

Line 1685: FROM per_all_assignments_f asg

1681: and pai.effective_date = lp_Tax_Year_End_Date
1682: and paa.effective_start_date =
1683: (
1684: SELECT MIN(asg.effective_start_date)
1685: FROM per_all_assignments_f asg
1686: WHERE asg.assignment_id = paa.assignment_id
1687: and asg.payroll_id is not NULL
1688: and asg.effective_start_date <= least(nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date), lp_Tax_Year_End_Date)
1689: and nvl(asg.effective_end_date, lp_Tax_Year_End_Date) >= ppos.date_start

Line 1762: per_all_assignments_f paa

1758: hoi.org_information1 leg_tax_ref
1759: from hr_organization_units hou,
1760: hr_organization_information hoi,
1761: hr_organization_information hoi1,
1762: per_all_assignments_f paa
1763: where paa.assignment_id = p_assignment_id
1764: and hou.organization_id = nvl(paa.establishment_id,-1)
1765: and hoi.organization_id = hou.organization_id
1766: and hoi1.organization_id = hou.organization_id

Line 1776: FROM per_all_assignments_f asg

1772: and hoi.org_information2 IS NOT NULL
1773: and paa.effective_start_date =
1774: (
1775: SELECT MIN(asg.effective_start_date)
1776: FROM per_all_assignments_f asg
1777: WHERE asg.assignment_id = paa.assignment_id
1778: and asg.effective_start_date <= p_tax_year_end_date
1779: and nvl(asg.effective_end_date, p_tax_year_end_date) >= p_tax_year_start_date
1780: