[Home] [Help]
559: ln_user_entity_id number := 0;
560:
561: cursor c_puerto_rico_gre_info (cp_tax_unit_id in number) is
562: select 'Y'
563: from hr_organization_information
564: where organization_id = cp_tax_unit_id
565: and org_information16 = 'P'
566: and org_information_context = 'W2 Reporting Rules';
567:
739: lv_all_1099_balances VARCHAR2(500);
740:
741: cursor c_1099_gre_info(cp_tax_unit_id in number) is
742: select hoi.org_information2
743: from hr_organization_information hoi
744: where hoi.organization_id = cp_tax_unit_id
745: and hoi.org_information_context = '1099R Magnetic Report Rules';
746:
747: cursor c_balance_feed_info(cp_balance_name in varchar2) is
1889:
1890: cursor c_get_state_code is
1891: select state_code
1892: from pay_us_states pus,
1893: hr_organization_information hoi
1894: where hoi.organization_id = p_tax_unit_id
1895: and hoi.org_information_context || '' = 'State Tax Rules'
1896: and pus.state_abbrev = hoi.org_information1
1897: and pus.state_code = decode(p_state_code,'ALL',pus.state_code,p_state_code);
2037: l_value2,
2038: l_value3
2039: from hr_locations hrl,
2040: hr_all_organization_units hou,
2041: hr_organization_information hoi
2042: where hou.organization_id = p_tax_unit_id
2043: and hoi.organization_id = hou.organization_id
2044: and hoi.org_information_context||'' = 'Employer Identification'
2045: and hrl.location_id = hou.location_id;
2106: select substr(hoi.org_information2,1,240),
2107: substr(hoi.org_information1,1,240)
2108: into l_value1,
2109: l_value2
2110: from hr_organization_information hoi
2111: where hoi.organization_id = p_tax_unit_id
2112: and hoi.org_information_context || '' = '1099R Magnetic Report Rules';
2113: exception
2114: when no_data_found then
2157:
2158: select substr(hoi2.org_information3,1,240),
2159: substr(hoi2.org_information4,1,240)
2160: into l_value1, l_value2
2161: from hr_organization_information hoi2,
2162: hr_organization_information hoi
2163: where hoi.organization_id = p_tax_unit_id
2164: and hoi.org_information_context||'' = '1099R Magnetic Report Rules'
2165: and hoi.org_information_context = hoi2.org_information_context
2158: select substr(hoi2.org_information3,1,240),
2159: substr(hoi2.org_information4,1,240)
2160: into l_value1, l_value2
2161: from hr_organization_information hoi2,
2162: hr_organization_information hoi
2163: where hoi.organization_id = p_tax_unit_id
2164: and hoi.org_information_context||'' = '1099R Magnetic Report Rules'
2165: and hoi.org_information_context = hoi2.org_information_context
2166: and hoi.org_information2 = hoi2.org_information2
2265: --l_value13,
2266: --l_value14,
2267: --l_value15, /* Job Development Fee (AL) */
2268: l_value16
2269: from hr_organization_information hoi
2270: where hoi.organization_id = p_tax_unit_id
2271: and hoi.org_information_context || '' = 'W2 Reporting Rules';
2272: exception
2273: when no_data_found then
2398: select hoi.org_information4 value1,
2399: hoi.org_information8 value2
2400: into l_value1,
2401: l_value2
2402: from hr_organization_information hoi
2403: where hoi.organization_id = p_tax_unit_id
2404: and hoi.org_information_context || '' = 'Federal Tax Rules';
2405: exception
2406: when no_data_found then
2491: l_value2,
2492: l_value3
2493: from pay_state_rules rules,
2494: pay_us_states pus,
2495: hr_organization_information target
2496: where substr(rules.jurisdiction_code, 1, 2) = c_state.state_code
2497: and target.organization_id = p_tax_unit_id
2498: and target.org_information_context || '' = 'State Tax Rules'
2499: and target.org_information1 = pus.state_abbrev
4513: begin
4514: l_processed := 'Z';
4515:
4516: select hou.name into l_gre_name
4517: from hr_organization_information hoi,
4518: hr_organization_units hou
4519: where hoi.org_information_context = 'CLASS'
4520: and hoi.org_information1 = 'HR_LEGAL'
4521: and hoi.organization_id = hou.organization_id