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_SQWL_GRE dependencies on HR_ORGANIZATION_INFORMATION

Line 99: FROM hr_organization_information hoi

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

Line 118: FROM hr_organization_information hoi2

114: )
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

Line 139: FROM hr_organization_information HOI,

135: /* Before adding this and clause the filenames in the SQWL report were having
136: redundant characters like { ] */
137:
138: /*SELECT distinct puar.tax_unit_id
139: FROM hr_organization_information HOI,
140: per_assignments_f ASG,
141: pay_us_asg_reporting puar,
142: pay_state_rules SR
143: WHERE SR.state_code = 'NY' --l_state

Line 152: from hr_organization_information HOI2

148: AND ASG.effective_end_date >= to_date('01-JAN-2010') --l_start_date
149: AND ASG.business_group_id + 0 = 0 --l_business_group_id
150: AND (('NY' IN ( 'CA','ME'))
151: OR (not exists (select 'x'
152: from hr_organization_information HOI2
153: where HOI2.organization_id = puar.tax_unit_id
154: AND HOI2.ORG_INFORMATION_CONTEXT = '1099R Magnetic Report Rules'
155: AND HOI2.ORG_INFORMATION2 is not null)))
156: AND HOI.organization_id = puar.tax_unit_id

Line 641: FROM hr_organization_information hoi

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

Line 660: FROM hr_organization_information hoi2

656: )
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

Line 682: FROM hr_organization_information HOI,

678: redundant characters like { ] */
679:
680:
681: /*SELECT distinct puar.tax_unit_id
682: FROM hr_organization_information HOI,
683: per_assignments_f ASG,
684: pay_us_asg_reporting puar,
685: pay_state_rules SR
686: WHERE SR.state_code = 'NY' --l_state

Line 695: from hr_organization_information HOI2

691: AND ASG.effective_end_date >= to_date('01-JAN-2010') --l_start_date
692: AND ASG.business_group_id + 0 = 0 --l_business_group_id
693: AND (('NY' IN ( 'CA','ME'))
694: OR (not exists (select 'x'
695: from hr_organization_information HOI2
696: where HOI2.organization_id = puar.tax_unit_id
697: AND HOI2.ORG_INFORMATION_CONTEXT = '1099R Magnetic Report Rules'
698: AND HOI2.ORG_INFORMATION2 is not null)))
699: AND HOI.organization_id = puar.tax_unit_id