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 HR_ORGANIZATION_INFORMATION

Line 86: hr_organization_information hoi

82: per_all_assignments_f paa,
83: per_all_people_f pap,
84: per_periods_of_service ppos,
85: hr_organization_units hou,
86: hr_organization_information hoi
87: where
88: pai.action_context_type = 'AAP'
89: and assact.payroll_action_id = lp_archive_action
90: and pai.action_context_id = assact.assignment_action_id

Line 128: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'

124: per_organization_structures pos,
125: per_org_structure_versions posv
126: where pos.organization_structure_id = posv.organization_structure_id
127: and to_char(pos.organization_structure_id) IN (select org_information1
128: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
129: and hoi.organization_id=lp_business_group_id)
130: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/
131:
132: CURSOR csr_get_org_name(lp_org_id number) IS

Line 179: hr_organization_information hoi,

175: CURSOR csr_get_leg_employer(p_assignment_id NUMBER, p_tax_year_start_date DATE, p_tax_year_end_date DATE) IS
176: select hou.organization_id leg_emp_id,
177: hoi.org_information1 leg_tax_ref
178: from hr_organization_units hou,
179: hr_organization_information hoi,
180: hr_organization_information hoi1,
181: per_all_assignments_f paa
182: where paa.assignment_id = p_assignment_id
183: and hou.organization_id = nvl(paa.establishment_id,-1)

Line 180: hr_organization_information hoi1,

176: select hou.organization_id leg_emp_id,
177: hoi.org_information1 leg_tax_ref
178: from hr_organization_units hou,
179: hr_organization_information hoi,
180: hr_organization_information hoi1,
181: per_all_assignments_f paa
182: where paa.assignment_id = p_assignment_id
183: and hou.organization_id = nvl(paa.establishment_id,-1)
184: and hoi.organization_id = hou.organization_id

Line 1714: hr_organization_information hoi

1710: per_all_assignments_f paa,
1711: per_all_people_f pap,
1712: per_periods_of_service ppos,
1713: hr_organization_units hou,
1714: hr_organization_information hoi
1715: where
1716: pai.action_context_type = 'AAP'
1717: and assact.payroll_action_id = lp_archive_action
1718: and pai.action_context_id = assact.assignment_action_id

Line 1756: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'

1752: per_organization_structures pos,
1753: per_org_structure_versions posv
1754: where pos.organization_structure_id = posv.organization_structure_id
1755: and to_char(pos.organization_structure_id) IN (select org_information1
1756: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
1757: and hoi.organization_id=lp_business_group_id)
1758: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/
1759:
1760: CURSOR csr_get_org_name(lp_org_id number) IS

Line 1807: hr_organization_information hoi,

1803: CURSOR csr_get_leg_employer(p_assignment_id NUMBER, p_tax_year_start_date DATE, p_tax_year_end_date DATE) IS
1804: select hou.organization_id leg_emp_id,
1805: hoi.org_information1 leg_tax_ref
1806: from hr_organization_units hou,
1807: hr_organization_information hoi,
1808: hr_organization_information hoi1,
1809: per_all_assignments_f paa
1810: where paa.assignment_id = p_assignment_id
1811: and hou.organization_id = nvl(paa.establishment_id,-1)

Line 1808: hr_organization_information hoi1,

1804: select hou.organization_id leg_emp_id,
1805: hoi.org_information1 leg_tax_ref
1806: from hr_organization_units hou,
1807: hr_organization_information hoi,
1808: hr_organization_information hoi1,
1809: per_all_assignments_f paa
1810: where paa.assignment_id = p_assignment_id
1811: and hou.organization_id = nvl(paa.establishment_id,-1)
1812: and hoi.organization_id = hou.organization_id