[Home] [Help]
182: cursor tcc_1099R_cur(p_tax_unit_id NUMBER, p_business_group_id NUMBER) is
183: /*4583577 Perf change 1 start*/
184: select hoi2.org_information2
185: from hr_all_organization_units hou,
186: hr_organization_information hoi2 -- 1099R transmitter
187: where hou.business_group_id + 0 = p_business_group_id
188: and hou.organization_id = p_tax_unit_id
189: and hoi2.organization_id = hou.organization_id
190: and hoi2.org_information_context = '1099R Magnetic Report Rules'
189: and hoi2.organization_id = hou.organization_id
190: and hoi2.org_information_context = '1099R Magnetic Report Rules'
191: and exists
192: (select 'Y'
193: from hr_all_organization_units hou1, hr_organization_information hoi
194: where hou1.business_group_id + 0 = p_business_group_id
195: and hou1.organization_id = p_tax_unit_id
196: and hou1.organization_id = hoi.organization_id
197: and hoi.org_information_context = 'CLASS'
478:
479: Cursor c_1099_fed_gre(p_trans_cont_code VARCHAR2) is
480: select hou.organization_id, hoi2.org_information1
481: from hr_all_organization_units hou,
482: hr_organization_information hoi,
483: hr_organization_information hoi2
484: where hou.business_group_id + 0 = p_business_group_id
485: and hou.organization_id = hoi.organization_id
486: and hoi.org_information_context = 'CLASS'
479: Cursor c_1099_fed_gre(p_trans_cont_code VARCHAR2) is
480: select hou.organization_id, hoi2.org_information1
481: from hr_all_organization_units hou,
482: hr_organization_information hoi,
483: hr_organization_information hoi2
484: where hou.business_group_id + 0 = p_business_group_id
485: and hou.organization_id = hoi.organization_id
486: and hoi.org_information_context = 'CLASS'
487: and hoi.org_information1 = 'HR_LEGAL'
488: and hoi.organization_id = hoi2.organization_id
489: and hoi2.org_information_context = '1099R Magnetic Report Rules'
490: and hou.organization_id in (
491: select organization_id
492: from hr_organization_information
493: where org_information_context = '1099R Magnetic Report Rules'
494: and org_information2 = p_trans_cont_code)
495: order by 2 desc;
496:
532: -- Cursor to check Transmitter Contact Information for the 'T' record
533:
534: Cursor c_chk_cntc_info (cp_trans_control_code varchar2, cp_tax_unit_id number) IS
535: select 'Y'
536: from hr_organization_information hoi
537: where hoi.organization_id = cp_tax_unit_id
538: and hoi.org_information_context = '1099R Magnetic Report Rules'
539: and hoi.org_information1 = 'Y'
540: and hoi.org_information2 = cp_trans_control_code
546:
547: Cursor c_chk_vnd_type (cp_trans_control_code varchar2,
548: cp_tax_unit_id number) IS
549: select hoi.org_information11
550: from hr_organization_information hoi
551: where hoi.organization_id = cp_tax_unit_id
552: and hoi.org_information_context = '1099R Magnetic Report Rules'
553: and hoi.org_information1 = 'Y'
554: and hoi.org_information2 = cp_trans_control_code;
558: -- Cursor to check Transmitter Vendor Information for the 'T' record
559: --
560: Cursor c_chk_vnd_info (cp_trans_control_code varchar2,
561: cp_tax_unit_id number) IS
562: select 'Y' from hr_organization_information hoi
563: where hoi.organization_id = cp_tax_unit_id
564: and hoi.org_information_context = '1099R Magnetic Report Rules'
565: and hoi.org_information1 = 'Y'
566: and hoi.org_information2 = cp_trans_control_code
854: --and hsck.segment1 = paa.tax_unit_id
855: --and hsck.segment1 in
856: and paa.tax_unit_id in
857: (select hoi.organization_id
858: from hr_organization_information hoi
859: where hoi.org_information_context = ''1099R Magnetic Report Rules'')
860: order by paf.person_id';
861:
862: hr_utility.set_location('pay_us_1099r_mag_reporting.range_cursor', 60);
895: --and hsck.segment1 = psv.tax_unit_id
896: --and hsck.segment1 in
897: and psv.tax_unit_id in
898: (select hoi.organization_id
899: from hr_organization_information hoi
900: where hoi.org_information_context = ''1099R Magnetic Report Rules'')
901: order by paf.person_id';
902:
903: hr_utility.set_location('pay_us_1099r_mag_reporting.range_cursor', 80);