APPS.PAY_CA_EOY_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 536: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;

532: checking against the new values returned from within the loop on the
533: next iteration. */
534:
535: l_prev_person_id per_all_people_f.person_id%type;
536: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
537:
538: /* Variable to hold the jurisdiction code used as a context for state
539: reporting. */
540:

Line 1353: hr_all_organization_units

1349: cursor cur_bg(p_tax_unit_id1 number) is
1350: select
1351: business_group_id
1352: from
1353: hr_all_organization_units
1354: where
1355: organization_id = p_tax_unit_id1;
1356:
1357: cursor employer_info is

Line 1372: hr_all_organization_units hou,

1368: hl.POSTAL_CODE GRE_postal_code,
1369: hl.COUNTRY GRE_country,
1370: hoi6.org_information3 ei_rate
1371: from
1372: hr_all_organization_units hou,
1373: hr_organization_information hoi6,
1374: hr_locations_all hl
1375: where
1376: hou.organization_id = p_tax_unit_id

Line 1420: hr_all_organization_units hou,

1416: hoi2.ORG_INFORMATION9 trans_tech_contact_lang,
1417: hoi2.ORG_INFORMATION17 trans_tech_contact_extn,
1418: hoi2.ORG_INFORMATION18 trans_tech_contact_email
1419: from
1420: hr_all_organization_units hou,
1421: hr_organization_information hoi2,
1422: hr_organization_information hoi3,
1423: hr_locations_all hl
1424: where

Line 2140: from hr_all_organization_units

2136:
2137:
2138: cursor cur_bg(p_tax_unit_id1 number) is
2139: select business_group_id
2140: from hr_all_organization_units
2141: where organization_id = p_tax_unit_id1;
2142:
2143: /* New cursors added for Federal YE Amendment Pre-Process Validation */
2144: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS