APPS.PAY_NL_ATS_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 85: hr_organization_units hou,

81: pay_action_information pai,
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

Line 134: from hr_organization_units

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
133: select name
134: from hr_organization_units
135: where organization_id = lp_org_id;
136:
137: CURSOR csr_get_person_name(lp_person_id number,lp_effective_date date) IS
138: select full_name from per_all_people_f

Line 154: hr_organization_units hou

150: hlc.town_or_city city,
151: pay_nl_general.get_country_name(hlc.country) country,
152: hlc.style add_style
153: from hr_locations hlc,
154: hr_organization_units hou
155: where hou.business_group_id = p_bg_id
156: and hou.organization_id = p_org_id
157: and hlc.location_id = hou.location_id;
158:

Line 178: from hr_organization_units hou,

174:
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

Line 1713: hr_organization_units hou,

1709: pay_action_information pai,
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

Line 1762: from hr_organization_units

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
1761: select name
1762: from hr_organization_units
1763: where organization_id = lp_org_id;
1764:
1765: CURSOR csr_get_person_name(lp_person_id number,lp_effective_date date) IS
1766: select full_name from per_all_people_f

Line 1782: hr_organization_units hou

1778: hlc.town_or_city city,
1779: pay_nl_general.get_country_name(hlc.country) country,
1780: hlc.style add_style
1781: from hr_locations hlc,
1782: hr_organization_units hou
1783: where hou.business_group_id = p_bg_id
1784: and hou.organization_id = p_org_id
1785: and hlc.location_id = hou.location_id;
1786:

Line 1806: from hr_organization_units hou,

1802:
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