APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 873: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;

869: checking against the new values returned from within the loop on the
870: next iteration. */
871:
872: l_prev_person_id per_all_people_f.person_id%type;
873: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
874:
875: /* Variable to hold the jurisdiction code used as a context for state
876: reporting. */
877:

Line 1345: hr_all_organization_units target2

1341: decode(target1.org_information3,'Y',target1.organization_id,
1342: to_number(target1.ORG_INFORMATION20)),
1343: target1.ORG_INFORMATION3
1344: from hr_organization_information target1,
1345: hr_all_organization_units target2
1346: where target1.organization_id = to_number(p_pre_org_id)
1347: and target2.business_group_id = l_business_group_id
1348: and target2.organization_id = target1.organization_id
1349: and target1.org_information_context = 'Prov Reporting Est'

Line 1414: from hr_all_organization_units O,

1410: , l_province_code
1411: , l_postal_code
1412: , l_country_code
1413: , l_org_name
1414: from hr_all_organization_units O,
1415: hr_locations_all L
1416: where L.LOCATION_ID = O.LOCATION_ID
1417: AND O.ORGANIZATION_ID = l_organization_id_of_qin;
1418:

Line 2199: hr_all_organization_units hou

2195: select decode(hoi.org_information3,'Y',hoi.organization_id,
2196: hoi.org_information20)
2197: into l_transmitter_id
2198: from hr_organization_information hoi,
2199: hr_all_organization_units hou
2200: WHERE hou.business_group_id = l_business_group_id
2201: and hoi.organization_id = hou.organization_id
2202: and hoi.org_information_context = 'Prov Reporting Est'
2203: and hoi.organization_id = to_number(l_pre_org_id)