APPS.PAY_NL_ATS_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 69: hr_organization_units hou,

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

Line 118: from hr_organization_units

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
117: select name
118: from hr_organization_units
119: where organization_id = lp_org_id;
120:
121: CURSOR csr_get_person_name(lp_person_id number,lp_effective_date date) IS
122: select full_name from per_all_people_f

Line 138: hr_organization_units hou

134: hlc.town_or_city city,
135: pay_nl_general.get_country_name(hlc.country) country,
136: hlc.style add_style
137: from hr_locations hlc,
138: hr_organization_units hou
139: where hou.business_group_id = p_bg_id
140: and hou.organization_id = p_org_id
141: and hlc.location_id = hou.location_id;
142:

Line 162: from hr_organization_units hou,

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

Line 1666: hr_organization_units hou,

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

Line 1715: from hr_organization_units

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
1714: select name
1715: from hr_organization_units
1716: where organization_id = lp_org_id;
1717:
1718: CURSOR csr_get_person_name(lp_person_id number,lp_effective_date date) IS
1719: select full_name from per_all_people_f

Line 1735: hr_organization_units hou

1731: hlc.town_or_city city,
1732: pay_nl_general.get_country_name(hlc.country) country,
1733: hlc.style add_style
1734: from hr_locations hlc,
1735: hr_organization_units hou
1736: where hou.business_group_id = p_bg_id
1737: and hou.organization_id = p_org_id
1738: and hlc.location_id = hou.location_id;
1739:

Line 1759: from hr_organization_units hou,

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