APPS.HR_US_W2_REP dependencies on HR_ORGANIZATION_UNITS

Line 320: hr_organization_units hou

316: cursor c_ny_st_match_fed (cp_tax_unit_id in number)
317: IS
318: select nvl(hoi.org_information1, 'Y')
319: from hr_organization_information hoi,
320: hr_organization_units hou
321: where hoi.organization_id = hou.business_group_id
322: and hou.organization_id = cp_tax_unit_id
323: and hoi.org_information_context = 'US State Tax Info';
324:

Line 1261: hr_organization_units hou

1257: 'STATE' ,region_2,
1258: 'COUNTRY',country,
1259: 'ZIP' ,postal_code,null)
1260: from hr_locations_all hl, /*Bug:2380518 fix */
1261: hr_organization_units hou
1262: where hou.organization_id = w2_tax_unit_id
1263: and hou.location_id = hl.location_id;
1264:
1265: addr_line hr_locations.address_line_1%type;

Line 1285: from hr_organization_units hou

1281:
1282: cursor c_bg is
1283: select
1284: business_group_id
1285: from hr_organization_units hou
1286: where hou.organization_id = w2_tax_unit_id;
1287:
1288: p_business_group_id hr_organization_units.business_group_id%type;
1289:

Line 1288: p_business_group_id hr_organization_units.business_group_id%type;

1284: business_group_id
1285: from hr_organization_units hou
1286: where hou.organization_id = w2_tax_unit_id;
1287:
1288: p_business_group_id hr_organization_units.business_group_id%type;
1289:
1290: begin
1291: OPEN c_bg;
1292: FETCH c_bg INTO p_business_group_id;

Line 1517: hr_organization_units hou

1513: hou.name
1514: into l_agent_tax_unit_id,
1515: l_agent_tax_unit_name
1516: from hr_organization_information hoi,
1517: hr_organization_units hou
1518: where hoi.org_information_context = 'W2 Reporting Rules'
1519: and hou.organization_id = hoi.organization_id
1520: and hou.business_group_id = p_business_group_id
1521: and nvl(org_information8, 'N') = 'Y'

Line 1533: hr_organization_units hou

1529: -- Get W2 Transmitter
1530: select hou.organization_id
1531: into l_w2_tax_unit_id
1532: from hr_organization_information hoi,
1533: hr_organization_units hou
1534: where hoi.org_information_context = 'W2 Reporting Rules'
1535: and hou.organization_id = hoi.organization_id
1536: and hou.business_group_id = p_business_group_id
1537: and nvl(org_information1, 'N') = 'Y' -- W2 Transmitter flag