DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on HR_ORGANIZATION_UNITS

Line 68: ,hr_organization_units hou

64: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
65: FROM hr_organization_information hoi
66: ,hr_organization_information ihoi
67: ,hr_organization_information choi
68: ,hr_organization_units hou
69: ,hr_locations_all hla
70: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
71: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
72: and hou.organization_id = hoi.organization_id

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: ,ff_user_entities fue1
202: ,ff_archive_items fai1

Line 283: ,hr_organization_units hou

279: ,pay_kr_nonstat_spay_efile_fun.get_prev_emp_count(xpaa.assignment_action_id)
280: FROM pay_assignment_actions xpaa
281: ,pay_payroll_actions xppa
282: ,hr_organization_information hoi
283: ,hr_organization_units hou
284: ,ff_user_entities fue
285: ,ff_archive_items fai
286: ,ff_user_entities fue1
287: ,ff_archive_items fai1