APPS.HR_US_W2_REP dependencies on HR_ORGANIZATION_INFORMATION

Line 289: from hr_organization_information hoi,

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

Line 797: from hr_organization_information

793: RETURN varchar2 IS
794:
795: CURSOR my_cursor IS
796: select ORG_INFORMATION3
797: from hr_organization_information
798: where organization_id = w2_tax_unit_id
799: and org_information_context = 'State Tax Rules'
800: and org_information1 = w2_state_abbrev;
801:

Line 803: state_id hr_organization_information.ORG_INFORMATION3%TYPE;

799: and org_information_context = 'State Tax Rules'
800: and org_information1 = w2_state_abbrev;
801:
802:
803: state_id hr_organization_information.ORG_INFORMATION3%TYPE;
804:
805: BEGIN
806: --
807: -- Get Employee State ID No for Box 16

Line 827: from hr_organization_information

823: w2_state_abbrev in varchar2)
824: RETURN varchar2 IS
825: CURSOR UI_cursor IS
826: select nvl(ORG_INFORMATION2,'NO STATE UI#')
827: from hr_organization_information
828: where organization_id = w2_tax_unit_id
829: and org_information_context = 'State Tax Rules'
830: and org_information1 = w2_state_abbrev;
831:

Line 833: ui_id hr_organization_information.ORG_INFORMATION2%TYPE;

829: and org_information_context = 'State Tax Rules'
830: and org_information1 = w2_state_abbrev;
831:
832:
833: ui_id hr_organization_information.ORG_INFORMATION2%TYPE;
834:
835: BEGIN
836:
837: -- Get Employee State UI ID No for Box 16 - NJ

Line 1401: from hr_organization_information hoi,

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

Line 1409: from hr_organization_information

1405: and hou.business_group_id = p_business_group_id
1406: and nvl(org_information8, 'N') = 'Y'
1407: and not exists (
1408: select 'Y'
1409: from hr_organization_information
1410: where organization_id = hou.organization_id
1411: and org_information_context = '1099R Magnetic Report Rules');
1412:
1413: begin

Line 1417: from hr_organization_information hoi,

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

Line 1425: from hr_organization_information

1421: and hou.business_group_id = p_business_group_id
1422: and nvl(org_information1, 'N') = 'Y' -- W2 Transmitter flag
1423: and not exists (
1424: select 'Y'
1425: from hr_organization_information
1426: where organization_id = hou.organization_id
1427: and org_information_context = '1099R Magnetic Report Rules');
1428:
1429: if l_agent_tax_unit_id = l_w2_tax_unit_id then -- is the Filer defined as W2 transmitter ?

Line 1543: from hr_organization_information

1539:
1540: cursor c_get_value_gre is
1541:
1542: select nvl(org_information18,'SDI')
1543: from hr_organization_information
1544: where organization_id = p_tax_unit_id
1545: and org_information_context = 'W2 Reporting Rules';
1546:
1547: l_box17_label varchar2(5);