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_UNITS

Line 15: ,hr_organization_units hou

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
19: WHERE xppa.action_type = 'X'

Line 16: ,hr_organization_units phou

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
19: WHERE xppa.action_type = 'X'
20: and xppa.action_status = 'C'

Line 91: ,hr_organization_units hou

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
95: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

Line 198: ,hr_organization_units hou

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'
202: and xppa.action_status = 'C'

Line 253: ,hr_organization_units hou

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
257: -- Bug 4253329

Line 314: ,hr_organization_units hou

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'
318: and xppa.action_status = 'C'