APPS.HR_US_W2_REP dependencies on HR_ORGANIZATION_INFORMATION

Line 319: from hr_organization_information hoi,

315: IS
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';

Line 912: from hr_organization_information

908: RETURN varchar2 IS
909:
910: CURSOR my_cursor IS
911: select ORG_INFORMATION3
912: from hr_organization_information
913: where organization_id = w2_tax_unit_id
914: and org_information_context = 'State Tax Rules'
915: and org_information1 = w2_state_abbrev;
916:

Line 918: state_id hr_organization_information.ORG_INFORMATION3%TYPE;

914: and org_information_context = 'State Tax Rules'
915: and org_information1 = w2_state_abbrev;
916:
917:
918: state_id hr_organization_information.ORG_INFORMATION3%TYPE;
919:
920: BEGIN
921: --
922: -- Get Employee State ID No for Box 16

Line 942: from hr_organization_information

938: w2_state_abbrev in varchar2)
939: RETURN varchar2 IS
940: CURSOR UI_cursor IS
941: select nvl(ORG_INFORMATION2,'NO STATE UI#')
942: from hr_organization_information
943: where organization_id = w2_tax_unit_id
944: and org_information_context = 'State Tax Rules'
945: and org_information1 = w2_state_abbrev;
946:

Line 948: ui_id hr_organization_information.ORG_INFORMATION2%TYPE;

944: and org_information_context = 'State Tax Rules'
945: and org_information1 = w2_state_abbrev;
946:
947:
948: ui_id hr_organization_information.ORG_INFORMATION2%TYPE;
949:
950: BEGIN
951:
952: -- Get Employee State UI ID No for Box 16 - NJ

Line 1516: from hr_organization_information hoi,

1512: select hou.organization_id,
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

Line 1524: from hr_organization_information

1520: and hou.business_group_id = p_business_group_id
1521: and nvl(org_information8, 'N') = 'Y'
1522: and not exists (
1523: select 'Y'
1524: from hr_organization_information
1525: where organization_id = hou.organization_id
1526: and org_information_context = '1099R Magnetic Report Rules');
1527:
1528: begin

Line 1532: from hr_organization_information hoi,

1528: begin
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

Line 1540: from hr_organization_information

1536: and hou.business_group_id = p_business_group_id
1537: and nvl(org_information1, 'N') = 'Y' -- W2 Transmitter flag
1538: and not exists (
1539: select 'Y'
1540: from hr_organization_information
1541: where organization_id = hou.organization_id
1542: and org_information_context = '1099R Magnetic Report Rules');
1543:
1544: if l_agent_tax_unit_id = l_w2_tax_unit_id then -- is the Filer defined as W2 transmitter ?

Line 1658: from hr_organization_information

1654:
1655: cursor c_get_value_gre is
1656:
1657: select nvl(org_information18,'SDI')
1658: from hr_organization_information
1659: where organization_id = p_tax_unit_id
1660: and org_information_context = 'W2 Reporting Rules';
1661:
1662: l_box17_label varchar2(5);