[Home] [Help]
591: ln_user_entity_id number := 0;
592:
593: cursor c_puerto_rico_gre_info (cp_tax_unit_id in number) is
594: select 'Y'
595: from hr_organization_information
596: where organization_id = cp_tax_unit_id
597: and org_information16 = 'P'
598: and org_information_context = 'W2 Reporting Rules';
599:
775: lv_all_1099_balances VARCHAR2(500);
776:
777: cursor c_1099_gre_info(cp_tax_unit_id in number) is
778: select hoi.org_information2
779: from hr_organization_information hoi
780: where hoi.organization_id = cp_tax_unit_id
781: and hoi.org_information_context = '1099R Magnetic Report Rules';
782:
783: cursor c_balance_feed_info(cp_balance_name in varchar2) is
2200:
2201: cursor c_get_state_code is
2202: select state_code
2203: from pay_us_states pus,
2204: hr_organization_information hoi
2205: where hoi.organization_id = p_tax_unit_id
2206: and hoi.org_information_context || '' = 'State Tax Rules'
2207: and pus.state_abbrev = hoi.org_information1
2208: and pus.state_code = decode(p_state_code,'ALL',pus.state_code,p_state_code);
2213: IS
2214: select
2215: substr(hoi.org_information10,1,6) value1,
2216: hoi.org_information20 value2
2217: from hr_organization_information hoi
2218: where hoi.organization_id = p_tax_unit_id
2219: and hoi.org_information_context || '' = 'PSD Reporting Rules';
2220:
2221:
2405: l_value2,
2406: l_value3
2407: from hr_locations hrl,
2408: hr_all_organization_units hou,
2409: hr_organization_information hoi
2410: where hou.organization_id = p_tax_unit_id
2411: and hoi.organization_id = hou.organization_id
2412: and hoi.org_information_context||'' = 'Employer Identification'
2413: and hrl.location_id = hou.location_id;
2474: select substr(hoi.org_information2,1,240),
2475: substr(hoi.org_information1,1,240)
2476: into l_value1,
2477: l_value2
2478: from hr_organization_information hoi
2479: where hoi.organization_id = p_tax_unit_id
2480: and hoi.org_information_context || '' = '1099R Magnetic Report Rules';
2481: exception
2482: when no_data_found then
2525:
2526: select substr(hoi2.org_information3,1,240),
2527: substr(hoi2.org_information4,1,240)
2528: into l_value1, l_value2
2529: from hr_organization_information hoi2,
2530: hr_organization_information hoi
2531: where hoi.organization_id = p_tax_unit_id
2532: and hoi.org_information_context||'' = '1099R Magnetic Report Rules'
2533: and hoi.org_information_context = hoi2.org_information_context
2526: select substr(hoi2.org_information3,1,240),
2527: substr(hoi2.org_information4,1,240)
2528: into l_value1, l_value2
2529: from hr_organization_information hoi2,
2530: hr_organization_information hoi
2531: where hoi.organization_id = p_tax_unit_id
2532: and hoi.org_information_context||'' = '1099R Magnetic Report Rules'
2533: and hoi.org_information_context = hoi2.org_information_context
2534: and hoi.org_information2 = hoi2.org_information2
2637: --l_value15, /* Job Development Fee (AL) */
2638: l_value16,
2639: l_value19, -- Bug 6928011 access code (PR)
2640: l_value20
2641: from hr_organization_information hoi
2642: where hoi.organization_id = p_tax_unit_id
2643: and hoi.org_information_context || '' = 'W2 Reporting Rules';
2644: exception
2645: when no_data_found then
2777:
2778: begin
2779: select hoi.org_information1 value1
2780: into l_value1
2781: from hr_organization_information hoi
2782: where hoi.organization_id = p_tax_unit_id
2783: and hoi.org_information_context || '' = 'W2 Reporting Rules 1';
2784: exception
2785: when no_data_found then
2908: select hoi.org_information4 value1,
2909: hoi.org_information8 value2
2910: into l_value1,
2911: l_value2
2912: from hr_organization_information hoi
2913: where hoi.organization_id = p_tax_unit_id
2914: and hoi.org_information_context || '' = 'Federal Tax Rules';
2915: exception
2916: when no_data_found then
3001: l_value2,
3002: l_value3
3003: from pay_state_rules rules,
3004: pay_us_states pus,
3005: hr_organization_information target
3006: where substr(rules.jurisdiction_code, 1, 2) = c_state.state_code
3007: and target.organization_id = p_tax_unit_id
3008: and target.org_information_context || '' = 'State Tax Rules'
3009: and target.org_information1 = pus.state_abbrev
5345: begin
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