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 70: hr_organization_information hoi

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
71: where
72: pai.action_context_type = 'AAP'
73: and assact.payroll_action_id = lp_archive_action
74: and pai.action_context_id = assact.assignment_action_id

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

108: per_organization_structures pos,
109: per_org_structure_versions posv
110: where pos.organization_structure_id = posv.organization_structure_id
111: and to_char(pos.organization_structure_id) IN (select org_information1
112: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
113: and hoi.organization_id=lp_business_group_id)
114: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/
115:
116: CURSOR csr_get_org_name(lp_org_id number) IS

Line 163: hr_organization_information hoi,

159: CURSOR csr_get_leg_employer(p_assignment_id NUMBER, p_tax_year_start_date DATE, p_tax_year_end_date DATE) IS
160: select hou.organization_id leg_emp_id,
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)

Line 164: hr_organization_information hoi1,

160: select hou.organization_id leg_emp_id,
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

Line 1667: hr_organization_information hoi

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
1668: where
1669: pai.action_context_type = 'AAP'
1670: and assact.payroll_action_id = lp_archive_action
1671: and pai.action_context_id = assact.assignment_action_id

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

1705: per_organization_structures pos,
1706: per_org_structure_versions posv
1707: where pos.organization_structure_id = posv.organization_structure_id
1708: and to_char(pos.organization_structure_id) IN (select org_information1
1709: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
1710: and hoi.organization_id=lp_business_group_id)
1711: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/
1712:
1713: CURSOR csr_get_org_name(lp_org_id number) IS

Line 1760: hr_organization_information hoi,

1756: CURSOR csr_get_leg_employer(p_assignment_id NUMBER, p_tax_year_start_date DATE, p_tax_year_end_date DATE) IS
1757: select hou.organization_id leg_emp_id,
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)

Line 1761: hr_organization_information hoi1,

1757: select hou.organization_id leg_emp_id,
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