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.

[Home] [Help]

APPS.PAY_US_SQWL_GRE dependencies on HR_ORGANIZATION_UNITS

Line 100: ,hr_organization_units hou1

96: CURSOR c_get_all_gres is
97: SELECT DISTINCT
98: hoi.organization_id
99: FROM hr_organization_information hoi
100: ,hr_organization_units hou1
101: WHERE hoi.org_information1 = p_state
102: AND hou1.business_group_id = p_business_group_id
103: AND hoi.organization_id = hou1.organization_id
104: AND hoi.org_information_context = 'State Tax Rules'

Line 119: ,hr_organization_units hou2

115: OR NOT EXISTS
116: (
117: SELECT 'x'
118: FROM hr_organization_information hoi2
119: ,hr_organization_units hou2
120: WHERE hoi2.organization_id = hoi.organization_id
121: AND hoi2.org_information_context = '1099R Magnetic Report Rules'
122: AND hoi2.org_information2 IS NOT NULL
123: AND hou2.business_group_id = p_business_group_id

Line 642: ,hr_organization_units hou1

638: CURSOR c_get_all_gres is
639: SELECT DISTINCT
640: hoi.organization_id
641: FROM hr_organization_information hoi
642: ,hr_organization_units hou1
643: WHERE hoi.org_information1 = p_state
644: AND hou1.business_group_id = p_business_group_id
645: AND hoi.organization_id = hou1.organization_id
646: AND hoi.org_information_context = 'State Tax Rules'

Line 661: ,hr_organization_units hou2

657: OR NOT EXISTS
658: (
659: SELECT 'x'
660: FROM hr_organization_information hoi2
661: ,hr_organization_units hou2
662: WHERE hoi2.organization_id = hoi.organization_id
663: AND hoi2.org_information_context = '1099R Magnetic Report Rules'
664: AND hoi2.org_information2 IS NOT NULL
665: AND hou2.business_group_id = p_business_group_id