APPS.PAY_KW_PAYROLL_REGISTER dependencies on HR_ALL_ORGANIZATION_UNITS

Line 139: from hr_all_organization_units

135:
136: /* SELECTS BUSINESS GROUP ID FOR ORGANIZATION SPECIFIED */
137: CURSOR csr_get_bg_id_org (l_org_id number) IS
138: select business_group_id
139: from hr_all_organization_units
140: where ORGANIZATION_ID = l_org_id;
141: /* SELECTS BUSINESS GROUP ID FROM THE PAYROLL SPECIFIED */
142: CURSOR csr_get_bg_id_pay (l_payroll_id number , l_effective_date date) IS
143: select business_group_id

Line 156: from hr_all_organization_units

152: and l_eff_date between effective_start_date and effective_end_date;
153: /* SELECTS ORGANIZATION NAME FOR HEADER */
154: CURSOR csr_get_organization_name (l_org_id number) IS
155: select name
156: from hr_all_organization_units
157: where ORGANIZATION_ID = l_org_id;
158: /* SELECTS ORGANIZATIONS COMING UNDER A PAYROLL */
159: CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
160: SELECT distinct pai_emp.action_information15 organization