APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 932: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;

928: checking against the new values returned from within the loop on the
929: next iteration. */
930:
931: l_prev_person_id per_all_people_f.person_id%type;
932: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
933:
934: /* Variable to hold the jurisdiction code used as a context for state
935: reporting. */
936:

Line 1515: hr_all_organization_units target2

1511: decode(target1.org_information3,'Y',target1.organization_id,
1512: to_number(target1.ORG_INFORMATION20)),
1513: target1.ORG_INFORMATION3
1514: from hr_organization_information target1,
1515: hr_all_organization_units target2
1516: where target1.organization_id = to_number(p_pre_org_id)
1517: and target2.business_group_id = l_business_group_id
1518: and target2.organization_id = target1.organization_id
1519: and target1.org_information_context = 'Prov Reporting Est'

Line 1584: from hr_all_organization_units O,

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

Line 2905: hr_all_organization_units hou

2901: select decode(hoi.org_information3,'Y',hoi.organization_id,
2902: hoi.org_information20)
2903: into l_transmitter_id
2904: from hr_organization_information hoi,
2905: hr_all_organization_units hou
2906: WHERE hou.business_group_id = l_business_group_id
2907: and hoi.organization_id = hou.organization_id
2908: and hoi.org_information_context = 'Prov Reporting Est'
2909: and hoi.organization_id = to_number(l_pre_org_id)