DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on HR_ORGANIZATION_UNITS

Line 137: ,hr_organization_units hou

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

Line 196: ,hr_organization_units hou

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