DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on HR_ORGANIZATION_UNITS

Line 141: ,hr_organization_units hou

137: ,nvl(pap.email_address,' ')
138: FROM hr_organization_information hoi
139: ,hr_locations_all hlc --Modified the table from hr_locations to hr_locations_all
140: ,fnd_territories_tl ftl
141: ,hr_organization_units hou
142: ,per_people_f pap
143: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
144: AND hou.organization_id = hoi.organization_id
145: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')

Line 200: ,hr_organization_units hou

196: ,hoi.org_information14
197: FROM hr_organization_information hoi
198: ,hr_locations_all hlc --Modified the table from hr_locations to hr_locations_all
199: ,fnd_territories_tl ftl
200: ,hr_organization_units hou
201: ,per_people_f pap
202: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
203: AND hou.organization_id = hoi.organization_id
204: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')