DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on HR_ORGANIZATION_UNITS

Line 74: ,hr_organization_units hou

70: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
71: FROM hr_organization_information hoi
72: ,hr_organization_information ihoi
73: ,hr_organization_information choi
74: ,hr_organization_units hou
75: ,hr_locations_all hla
76: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
77: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
78: and hou.organization_id = hoi.organization_id

Line 259: ,hr_organization_units hou

255: FROM pay_assignment_actions xpaa
256: ,pay_payroll_actions xppa
257: ,hr_organization_information hoi
258: ,hr_organization_information ihoi
259: ,hr_organization_units hou
260: ,ff_user_entities fue
261: ,ff_archive_items fai
262: ,ff_user_entities fue1
263: ,ff_archive_items fai1

Line 401: ,hr_organization_units hou

397:
398: FROM pay_assignment_actions xpaa
399: ,pay_payroll_actions xppa
400: ,hr_organization_information hoi
401: ,hr_organization_units hou
402: ,ff_user_entities fue
403: ,ff_archive_items fai
404: ,ff_user_entities fue1
405: ,ff_archive_items fai1