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

Line 14: ,hr_organization_information hoi

10: ,'CORPORATION_ID=P'
11: ,hoi.org_information10
12: FROM pay_assignment_actions xpaa
13: ,pay_payroll_actions xppa
14: ,hr_organization_information hoi
15: ,hr_organization_units hou
16: ,hr_organization_units phou
17: ,hr_organization_information phoi
18: ,hr_organization_information ihoi

Line 17: ,hr_organization_information phoi

13: ,pay_payroll_actions xppa
14: ,hr_organization_information hoi
15: ,hr_organization_units hou
16: ,hr_organization_units phou
17: ,hr_organization_information phoi
18: ,hr_organization_information ihoi
19: WHERE xppa.action_type = 'X'
20: and xppa.action_status = 'C'
21: and xppa.effective_date between

Line 18: ,hr_organization_information ihoi

14: ,hr_organization_information hoi
15: ,hr_organization_units hou
16: ,hr_organization_units phou
17: ,hr_organization_information phoi
18: ,hr_organization_information ihoi
19: WHERE xppa.action_type = 'X'
20: and xppa.action_status = 'C'
21: and xppa.effective_date between
22: pay_magtape_generic.get_parameter_value('START_DATE')

Line 39: from hr_organization_information

35: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child
36: from PER_ORG_STRUCTURE_ELEMENTS posev
37: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
38: and exists ( select null
39: from hr_organization_information
40: where organization_id = posev.ORGANIZATION_ID_child
41: and org_information_context = 'CLASS'
42: and org_information1 = 'KR_BUSINESS_PLACE'
43: )

Line 88: FROM hr_organization_information hoi

84: ,'REPORTING_PERIOD=P'
85: ,'1' reporting_period
86: ,'HOME_TAX_ID=P'
87: ,nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
88: FROM hr_organization_information hoi
89: ,hr_organization_information ihoi
90: ,hr_organization_information choi
91: ,hr_organization_units hou
92: ,hr_locations_all hla

Line 89: ,hr_organization_information ihoi

85: ,'1' reporting_period
86: ,'HOME_TAX_ID=P'
87: ,nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
88: FROM hr_organization_information hoi
89: ,hr_organization_information ihoi
90: ,hr_organization_information choi
91: ,hr_organization_units hou
92: ,hr_locations_all hla
93: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

Line 90: ,hr_organization_information choi

86: ,'HOME_TAX_ID=P'
87: ,nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
88: FROM hr_organization_information hoi
89: ,hr_organization_information ihoi
90: ,hr_organization_information choi
91: ,hr_organization_units hou
92: ,hr_locations_all hla
93: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
94: and hou.organization_id = hoi.organization_id

Line 134: ,hr_organization_information hoi

130: 'TAX_OFFICE_CODE=P',
131: ihoi.org_information9
132: FROM pay_assignment_actions xpaa
133: ,pay_payroll_actions xppa
134: ,hr_organization_information hoi
135: ,hr_organization_information ihoi
136: WHERE xppa.action_type = 'X'
137: and xppa.action_status = 'C'
138: and xppa.effective_date between

Line 135: ,hr_organization_information ihoi

131: ihoi.org_information9
132: FROM pay_assignment_actions xpaa
133: ,pay_payroll_actions xppa
134: ,hr_organization_information hoi
135: ,hr_organization_information ihoi
136: WHERE xppa.action_type = 'X'
137: and xppa.action_status = 'C'
138: and xppa.effective_date between
139: -- Bug 4253329

Line 158: from hr_organization_information

154: or ( (hoi.organization_id in ( select posev.ORGANIZATION_ID_child
155: from PER_ORG_STRUCTURE_ELEMENTS posev
156: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
157: and exists (select null
158: from hr_organization_information
159: where organization_id = posev.ORGANIZATION_ID_child
160: and org_information_context = 'CLASS'
161: and org_information1 = 'KR_BUSINESS_PLACE'
162: )

Line 196: ,hr_organization_information hoi

192: ,'PREV_EMP_COUNT=P'
193: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
194: FROM pay_assignment_actions xpaa
195: ,pay_payroll_actions xppa
196: ,hr_organization_information hoi
197: ,hr_organization_information ihoi
198: ,hr_organization_units hou
199: ,ff_user_entities fue
200: ,ff_archive_items fai

Line 197: ,hr_organization_information ihoi

193: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
194: FROM pay_assignment_actions xpaa
195: ,pay_payroll_actions xppa
196: ,hr_organization_information hoi
197: ,hr_organization_information ihoi
198: ,hr_organization_units hou
199: ,ff_user_entities fue
200: ,ff_archive_items fai
201: WHERE xppa.action_type = 'X'

Line 251: ,hr_organization_information hoi

247: SELECT 'ASSIGNMENT_ACTION_ID=C'
248: ,max(xpaa.assignment_action_id)
249: FROM pay_assignment_actions xpaa
250: ,pay_payroll_actions xppa
251: ,hr_organization_information hoi
252: ,hr_organization_information ihoi
253: ,hr_organization_units hou
254: WHERE xppa.action_type = 'X'
255: and xppa.action_status = 'C'

Line 252: ,hr_organization_information ihoi

248: ,max(xpaa.assignment_action_id)
249: FROM pay_assignment_actions xpaa
250: ,pay_payroll_actions xppa
251: ,hr_organization_information hoi
252: ,hr_organization_information ihoi
253: ,hr_organization_units hou
254: WHERE xppa.action_type = 'X'
255: and xppa.action_status = 'C'
256: and xppa.effective_date between

Line 312: ,hr_organization_information hoi

308: ,pay_run_types prt
309: -- End of 4201616
310: ,pay_assignment_actions xpaa
311: ,pay_payroll_actions xppa
312: ,hr_organization_information hoi
313: ,hr_organization_information ihoi
314: ,hr_organization_units hou
315: ,ff_user_entities fue
316: ,ff_archive_items fai

Line 313: ,hr_organization_information ihoi

309: -- End of 4201616
310: ,pay_assignment_actions xpaa
311: ,pay_payroll_actions xppa
312: ,hr_organization_information hoi
313: ,hr_organization_information ihoi
314: ,hr_organization_units hou
315: ,ff_user_entities fue
316: ,ff_archive_items fai
317: WHERE xppa.action_type = 'X'