APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1072: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;

1068: checking against the new values returned from within the loop on the
1069: next iteration. */
1070:
1071: l_prev_person_id per_all_people_f.person_id%type;
1072: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
1073:
1074: /* Variable to hold the jurisdiction code used as a context for state
1075: reporting. */
1076:

Line 1718: hr_all_organization_units target2

1714: decode(target1.org_information3,'Y',target1.organization_id,
1715: target1.ORG_INFORMATION20),
1716: target1.ORG_INFORMATION3
1717: from hr_organization_information target1 ,
1718: hr_all_organization_units target2
1719: where target1.organization_id = to_number(p_pre_organization_id)
1720: and target2.business_group_id = l_business_group_id
1721: and target2.organization_id = target1.organization_id
1722: and target1.org_information_context = 'Prov Reporting Est';

Line 1782: from hr_all_organization_units O,

1778: , l_town_or_city
1779: , l_province_code
1780: , l_postal_code
1781: , l_country_code
1782: from hr_all_organization_units O,
1783: hr_locations_all L
1784: where L.LOCATION_ID = O.LOCATION_ID
1785: AND O.ORGANIZATION_ID = l_organization_id_of_qin;
1786:

Line 1816: from hr_all_organization_units

1812:
1813: begin
1814: select name
1815: into l_transmitter_name
1816: from hr_all_organization_units
1817: where organization_id = l_transmitter_org_id;
1818:
1819: EXCEPTION
1820: when no_data_found then

Line 2338: hr_all_organization_units hou

2334: hoi.org_information20)
2335: into l_transmitter_name1
2336: from pay_payroll_actions ppa,
2337: hr_organization_information hoi,
2338: hr_all_organization_units hou
2339: WHERE hou.business_group_id = ppa.business_group_id
2340: and hoi.organization_id = hou.organization_id
2341: and hoi.org_information_context='Prov Reporting Est'
2342: and hoi.organization_id =

Line 2727: from hr_all_organization_units target1

2723: close c_get_max_asgactid_jd;
2724:
2725: select target1.business_group_id
2726: into l_business_group_id
2727: from hr_all_organization_units target1
2728: where target1.organization_id = l_tax_unit_id;
2729:
2730: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2731: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);

Line 3082: , hr_all_organization_units hou

3078: , pay_assignment_actions arch_paa
3079: , pay_payroll_actions arch_ppa
3080: , per_all_assignments_f arch_paf
3081: , per_all_assignments_f all_paf
3082: , hr_all_organization_units hou
3083: , hr_organization_information hoi
3084: where arch_paa.assignment_action_id = cp_asgactid
3085: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
3086: and hou.business_group_id + 0 = arch_ppa.business_group_id

Line 3679: from hr_all_organization_units target1

3675: l_no_of_payroll_run := l_no_of_payroll_run + 1;
3676:
3677: select target1.business_group_id
3678: into l_business_group_id
3679: from hr_all_organization_units target1
3680: where target1.organization_id = l_tax_unit_id;
3681:
3682: if l_tax_unit_id <> l_prev_tax_unit_id or
3683: l_prev_tax_unit_id is null then

Line 3982: from hr_all_organization_units target1

3978: l_no_of_payroll_run := l_no_of_payroll_run + 1;
3979:
3980: select target1.business_group_id
3981: into l_business_group_id
3982: from hr_all_organization_units target1
3983: where target1.organization_id = l_ft_tax_unit_id;
3984:
3985: if ( l_ft_tax_unit_id <> l_prev_tax_unit_id or
3986: l_prev_tax_unit_id is null )