APPS.PAY_AE_PAYROLL_REGISTER dependencies on HR_ALL_ORGANIZATION_UNITS

Line 137: from hr_all_organization_units

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

Line 154: from hr_all_organization_units

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