APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 984: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;

980: checking against the new values returned from within the loop on the
981: next iteration. */
982:
983: l_prev_person_id per_all_people_f.person_id%type;
984: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
985:
986: /* Variable to hold the jurisdiction code used as a context for state
987: reporting. */
988:

Line 1521: hr_all_organization_units target2

1517: decode(target1.org_information3,'Y',target1.organization_id,
1518: target1.ORG_INFORMATION20),
1519: target1.ORG_INFORMATION3
1520: from hr_organization_information target1 ,
1521: hr_all_organization_units target2
1522: where target1.organization_id = to_number(p_pre_organization_id)
1523: and target2.business_group_id = l_business_group_id
1524: and target2.organization_id = target1.organization_id
1525: and target1.org_information_context = 'Prov Reporting Est';

Line 1585: from hr_all_organization_units O,

1581: , l_town_or_city
1582: , l_province_code
1583: , l_postal_code
1584: , l_country_code
1585: from hr_all_organization_units O,
1586: hr_locations_all L
1587: where L.LOCATION_ID = O.LOCATION_ID
1588: AND O.ORGANIZATION_ID = l_organization_id_of_qin;
1589:

Line 1619: from hr_all_organization_units

1615:
1616: begin
1617: select name
1618: into l_transmitter_name
1619: from hr_all_organization_units
1620: where organization_id = l_transmitter_org_id;
1621:
1622: EXCEPTION
1623: when no_data_found then

Line 2259: , hr_all_organization_units hou

2255: , pay_assignment_actions arch_paa
2256: , pay_payroll_actions arch_ppa
2257: , per_all_assignments_f arch_paf
2258: , per_all_assignments_f all_paf
2259: , hr_all_organization_units hou
2260: , hr_organization_information hoi
2261: where arch_paa.assignment_action_id = cp_asgactid
2262: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
2263: and hou.business_group_id + 0 = arch_ppa.business_group_id

Line 2528: hr_all_organization_units hou

2524: hoi.org_information20)
2525: into l_transmitter_name1
2526: from pay_payroll_actions ppa,
2527: hr_organization_information hoi,
2528: hr_all_organization_units hou
2529: WHERE hou.business_group_id = ppa.business_group_id
2530: and hoi.organization_id = hou.organization_id
2531: and hoi.org_information_context='Prov Reporting Est'
2532: and hoi.organization_id =

Line 2864: from hr_all_organization_units target1

2860: l_no_of_payroll_run := l_no_of_payroll_run + 1;
2861:
2862: select target1.business_group_id
2863: into l_business_group_id
2864: from hr_all_organization_units target1
2865: where target1.organization_id = l_tax_unit_id;
2866:
2867: if l_tax_unit_id <> l_prev_tax_unit_id or
2868: l_prev_tax_unit_id is null then

Line 3164: from hr_all_organization_units target1

3160: l_no_of_payroll_run := l_no_of_payroll_run + 1;
3161:
3162: select target1.business_group_id
3163: into l_business_group_id
3164: from hr_all_organization_units target1
3165: where target1.organization_id = l_ft_tax_unit_id;
3166:
3167: if ( l_ft_tax_unit_id <> l_prev_tax_unit_id or
3168: l_prev_tax_unit_id is null )