APPS.PAY_US_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 1443: l_prev_tax_unit_id hr_organization_units.organization_id%type;

1439: /* Variables used to hold the current values returned within the loop for
1440: checking against the new values returned from within the loop on the
1441: next iteration. */
1442: l_prev_person_id per_people_f.person_id%type;
1443: l_prev_tax_unit_id hr_organization_units.organization_id%type;
1444:
1445: /* Variable to hold the jurisdiction code used as a context for state
1446: reporting. */
1447: l_jurisdiction_code varchar2(30);

Line 5312: l_gre_name hr_organization_units.name%TYPE;

5308:
5309: l_processed varchar2(20);
5310: l_mesg varchar2(100);
5311:
5312: l_gre_name hr_organization_units.name%TYPE;
5313:
5314: BEGIN
5315:
5316: l_step := 1;

Line 5350: hr_organization_units hou

5346: l_processed := 'Z';
5347:
5348: select hou.name into l_gre_name
5349: from hr_organization_information hoi,
5350: hr_organization_units hou
5351: where hoi.org_information_context = 'CLASS'
5352: and hoi.org_information1 = 'HR_LEGAL'
5353: and hoi.organization_id = hou.organization_id
5354: and hou.business_group_id = l_eoy_bg_id