APPS.HR_US_W2_REP dependencies on HR_ORGANIZATION_UNITS

Line 290: hr_organization_units hou

286: cursor c_ny_st_match_fed (cp_tax_unit_id in number)
287: IS
288: select nvl(hoi.org_information1, 'Y')
289: from hr_organization_information hoi,
290: hr_organization_units hou
291: where hoi.organization_id = hou.business_group_id
292: and hou.organization_id = cp_tax_unit_id
293: and hoi.org_information_context = 'US State Tax Info';
294:

Line 1146: hr_organization_units hou

1142: 'STATE' ,region_2,
1143: 'COUNTRY',country,
1144: 'ZIP' ,postal_code,null)
1145: from hr_locations_all hl, /*Bug:2380518 fix */
1146: hr_organization_units hou
1147: where hou.organization_id = w2_tax_unit_id
1148: and hou.location_id = hl.location_id;
1149:
1150: addr_line hr_locations.address_line_1%type;

Line 1170: from hr_organization_units hou

1166:
1167: cursor c_bg is
1168: select
1169: business_group_id
1170: from hr_organization_units hou
1171: where hou.organization_id = w2_tax_unit_id;
1172:
1173: p_business_group_id hr_organization_units.business_group_id%type;
1174:

Line 1173: p_business_group_id hr_organization_units.business_group_id%type;

1169: business_group_id
1170: from hr_organization_units hou
1171: where hou.organization_id = w2_tax_unit_id;
1172:
1173: p_business_group_id hr_organization_units.business_group_id%type;
1174:
1175: begin
1176: OPEN c_bg;
1177: FETCH c_bg INTO p_business_group_id;

Line 1402: hr_organization_units hou

1398: hou.name
1399: into l_agent_tax_unit_id,
1400: l_agent_tax_unit_name
1401: from hr_organization_information hoi,
1402: hr_organization_units hou
1403: where hoi.org_information_context = 'W2 Reporting Rules'
1404: and hou.organization_id = hoi.organization_id
1405: and hou.business_group_id = p_business_group_id
1406: and nvl(org_information8, 'N') = 'Y'

Line 1418: hr_organization_units hou

1414: -- Get W2 Transmitter
1415: select hou.organization_id
1416: into l_w2_tax_unit_id
1417: from hr_organization_information hoi,
1418: hr_organization_units hou
1419: where hoi.org_information_context = 'W2 Reporting Rules'
1420: and hou.organization_id = hoi.organization_id
1421: and hou.business_group_id = p_business_group_id
1422: and nvl(org_information1, 'N') = 'Y' -- W2 Transmitter flag