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

Line 123: , HR_ORGANIZATION_INFORMATION hoi1

119: and hsk.enabled_flag = 'Y'
120: and hsk.segment2 in (
121: select hoi2.org_information1
122: from HR_ORGANIZATION_UNITS o1
123: , HR_ORGANIZATION_INFORMATION hoi1
124: , HR_ORGANIZATION_INFORMATION hoi2
125: WHERE o1.business_group_id = ppa.business_group_id
126: and hoi1.organization_id = o1.organization_id
127: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))

Line 124: , HR_ORGANIZATION_INFORMATION hoi2

120: and hsk.segment2 in (
121: select hoi2.org_information1
122: from HR_ORGANIZATION_UNITS o1
123: , HR_ORGANIZATION_INFORMATION hoi1
124: , HR_ORGANIZATION_INFORMATION hoi2
125: WHERE o1.business_group_id = ppa.business_group_id
126: and hoi1.organization_id = o1.organization_id
127: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
128: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 203: , HR_ORGANIZATION_INFORMATION hoi1

199: and hsk.enabled_flag = 'Y'
200: and hsk.segment2 in (
201: select hoi2.org_information1
202: from HR_ORGANIZATION_UNITS o1
203: , HR_ORGANIZATION_INFORMATION hoi1
204: , HR_ORGANIZATION_INFORMATION hoi2
205: WHERE o1.business_group_id = pa1.business_group_id
206: and hoi1.organization_id = o1.organization_id
207: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))

Line 204: , HR_ORGANIZATION_INFORMATION hoi2

200: and hsk.segment2 in (
201: select hoi2.org_information1
202: from HR_ORGANIZATION_UNITS o1
203: , HR_ORGANIZATION_INFORMATION hoi1
204: , HR_ORGANIZATION_INFORMATION hoi2
205: WHERE o1.business_group_id = pa1.business_group_id
206: and hoi1.organization_id = o1.organization_id
207: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))
208: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 282: , HR_ORGANIZATION_INFORMATION hoi1

278: and hsk.enabled_flag = 'Y'
279: and hsk.segment2 in (
280: select hoi2.org_information1
281: from HR_ORGANIZATION_UNITS o1
282: , HR_ORGANIZATION_INFORMATION hoi1
283: , HR_ORGANIZATION_INFORMATION hoi2
284: WHERE o1.business_group_id = pa1.business_group_id
285: and hoi1.organization_id = o1.organization_id
286: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))

Line 283: , HR_ORGANIZATION_INFORMATION hoi2

279: and hsk.segment2 in (
280: select hoi2.org_information1
281: from HR_ORGANIZATION_UNITS o1
282: , HR_ORGANIZATION_INFORMATION hoi1
283: , HR_ORGANIZATION_INFORMATION hoi2
284: WHERE o1.business_group_id = pa1.business_group_id
285: and hoi1.organization_id = o1.organization_id
286: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'LEGAL_EMPLOYER'))
287: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 329: , HR_ORGANIZATION_INFORMATION hoi1

325: and hsk.SOFT_CODING_KEYFLEX_ID = paf.SOFT_CODING_KEYFLEX_ID
326: and hsk.segment2 in (
327: select hoi2.org_information1
328: from HR_ORGANIZATION_UNITS o1
329: , HR_ORGANIZATION_INFORMATION hoi1
330: , HR_ORGANIZATION_INFORMATION hoi2
331: WHERE o1.business_group_id = ppa.business_group_id
332: and hoi1.organization_id = o1.organization_id
333: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))

Line 330: , HR_ORGANIZATION_INFORMATION hoi2

326: and hsk.segment2 in (
327: select hoi2.org_information1
328: from HR_ORGANIZATION_UNITS o1
329: , HR_ORGANIZATION_INFORMATION hoi1
330: , HR_ORGANIZATION_INFORMATION hoi2
331: WHERE o1.business_group_id = ppa.business_group_id
332: and hoi1.organization_id = o1.organization_id
333: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'LEGAL_EMPLOYER'))
334: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'