APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 558: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;

554: checking against the new values returned from within the loop on the
555: next iteration. */
556:
557: l_prev_person_id per_all_people_f.person_id%type;
558: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
559:
560: /* Variable to hold the jurisdiction code used as a context for state
561: reporting. */
562:

Line 1423: from hr_all_organization_units ou1, /* transmitter org */

1419: -- Added for bug 10388148
1420: hoi2.ORG_INFORMATION14 trans_proprietor_SIN#1,
1421: hoi2.ORG_INFORMATION15 trans_proprietor_SIN#2
1422: -- Added for bug 10388148
1423: from hr_all_organization_units ou1, /* transmitter org */
1424: hr_organization_information hoi1, /* Transmitter GRE to check
1425: GRE/Legal Classification is enabled */
1426: hr_organization_information hoi2, /* Transmitter GRE to check
1427: 'Fed Magnetic Reporting' */

Line 1431: hr_all_organization_units ou2, /* GRE Org */

1427: 'Fed Magnetic Reporting' */
1428: hr_organization_information hoi3, /* Transmitter GRE to check
1429: 'Employer Identification' */
1430: hr_locations_all hl1, /* trans location */
1431: hr_all_organization_units ou2, /* GRE Org */
1432: hr_organization_information hoi4, /* GRE to check GRE/Legal
1433: Classification is enabled */
1434: hr_organization_information hoi6, /* GRE to check
1435: 'Employer Identification'*/

Line 2034: , hr_all_organization_units hou

2030: , pay_assignment_actions arch_paa
2031: , pay_payroll_actions arch_ppa
2032: , per_all_assignments_f arch_paf
2033: , per_all_assignments_f all_paf
2034: , hr_all_organization_units hou
2035: , hr_organization_information hoi
2036: where arch_paa.assignment_action_id = cp_asgact_id
2037: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
2038: and hou.business_group_id = arch_ppa.business_group_id

Line 2182: from hr_all_organization_units

2178:
2179: /* YE-2001 change to avoid hr_ca_tax_units_v view */
2180: select business_group_id
2181: into l_business_group_id
2182: from hr_all_organization_units
2183: where organization_id = l_tax_unit_id;
2184:
2185: l_step := 1;
2186:

Line 3447: , hr_all_organization_units hou

3443: , pay_assignment_actions arch_paa
3444: , pay_payroll_actions arch_ppa
3445: , per_all_assignments_f arch_paf
3446: , per_all_assignments_f all_paf
3447: , hr_all_organization_units hou
3448: , hr_organization_information hoi
3449: where arch_paa.assignment_action_id = cp_asgact_id
3450: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
3451: and hou.business_group_id = arch_ppa.business_group_id

Line 3621: from hr_all_organization_units

3617:
3618: /* YE-2001 change to avoid hr_ca_tax_units_v view */
3619: select business_group_id
3620: into l_business_group_id
3621: from hr_all_organization_units
3622: where organization_id = l_tax_unit_id;
3623:
3624: l_step := 1;
3625: