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=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 197: ,hr_organization_information hoi

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

Line 198: ,hr_organization_information ihoi

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

Line 254: ,hr_organization_information hoi

250: ,'REPORTING_PERIOD=P'
251: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')
252: FROM pay_assignment_actions xpaa
253: ,pay_payroll_actions xppa
254: ,hr_organization_information hoi
255: ,hr_organization_information ihoi
256: ,hr_organization_units hou
257: WHERE xppa.action_type = 'X'
258: and xppa.action_status = 'C'

Line 255: ,hr_organization_information ihoi

251: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')
252: FROM pay_assignment_actions xpaa
253: ,pay_payroll_actions xppa
254: ,hr_organization_information hoi
255: ,hr_organization_information ihoi
256: ,hr_organization_units hou
257: WHERE xppa.action_type = 'X'
258: and xppa.action_status = 'C'
259: and xppa.effective_date between

Line 319: ,hr_organization_information hoi

315: ,pay_run_types prt
316: -- End of 4201616
317: ,pay_assignment_actions xpaa
318: ,pay_payroll_actions xppa
319: ,hr_organization_information hoi
320: ,hr_organization_information ihoi
321: ,hr_organization_units hou
322: ,ff_user_entities fue
323: ,ff_archive_items fai

Line 320: ,hr_organization_information ihoi

316: -- End of 4201616
317: ,pay_assignment_actions xpaa
318: ,pay_payroll_actions xppa
319: ,hr_organization_information hoi
320: ,hr_organization_information ihoi
321: ,hr_organization_units hou
322: ,ff_user_entities fue
323: ,ff_archive_items fai
324: WHERE xppa.action_type = 'X'