eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_1099R_MAG_REPORTING dependencies on HR_ALL_ORGANIZATION_UNITS

Line 185: from hr_all_organization_units hou,

181:
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

Line 193: from hr_all_organization_units hou1, hr_organization_information hoi

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'

Line 481: from hr_all_organization_units hou,

477: -- GRE pop to the top to make that one process first.
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