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 199: ,hr_organization_units hou

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

Line 256: ,hr_organization_units hou

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

Line 321: ,hr_organization_units hou

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