APPS.PAY_CA_EOY_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 603: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;

599: checking against the new values returned from within the loop on the
600: next iteration. */
601:
602: l_prev_person_id per_all_people_f.person_id%type;
603: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
604:
605: /* Variable to hold the jurisdiction code used as a context for state
606: reporting. */
607:

Line 1530: hr_all_organization_units

1526: cursor cur_bg(p_tax_unit_id1 number) is
1527: select
1528: business_group_id
1529: from
1530: hr_all_organization_units
1531: where
1532: organization_id = p_tax_unit_id1;
1533:
1534: cursor employer_info is

Line 1549: hr_all_organization_units hou,

1545: hl.POSTAL_CODE GRE_postal_code,
1546: hl.COUNTRY GRE_country,
1547: hoi6.org_information3 ei_rate
1548: from
1549: hr_all_organization_units hou,
1550: hr_organization_information hoi6,
1551: hr_locations_all hl
1552: where
1553: hou.organization_id = p_tax_unit_id

Line 1605: hr_all_organization_units hou,

1601: -- Added for bug 10388148
1602: hoi2.ORG_INFORMATION17 trans_tech_contact_extn,
1603: hoi2.ORG_INFORMATION18 trans_tech_contact_email
1604: from
1605: hr_all_organization_units hou,
1606: hr_organization_information hoi2,
1607: hr_organization_information hoi3,
1608: hr_locations_all hl
1609: where

Line 2429: from hr_all_organization_units

2425: and paf.effective_end_date >= l_year_start;
2426:
2427: cursor cur_bg(p_tax_unit_id1 number) is
2428: select business_group_id
2429: from hr_all_organization_units
2430: where organization_id = p_tax_unit_id1;
2431:
2432: /* New cursors added for Federal YE Amendment Pre-Process Validation */
2433: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS