DBA Data[Home] [Help]

APPS.ZX_MIGRATE_UTIL dependencies on HR_ORGANIZATION_INFORMATION

Line 239: hr_organization_information oi,

235: substr(loc.style,1,2)
236: INTO l_country,
237: l_style
238: FROM hr_all_organization_units ou,
239: hr_organization_information oi,
240: hr_locations_all loc
241: WHERE ou.organization_id = oi.organization_id
242: AND ou.location_id = loc.location_id
243: AND oi.org_information_context = 'Operating Unit Information'

Line 251: hr_organization_information oi,

247: substr(loc.style,1,2)
248: INTO l_country,
249: l_style
250: FROM hr_all_organization_units ou,
251: hr_organization_information oi,
252: hr_locations_all loc
253: WHERE oi.organization_id = l_org_id
254: AND ou.organization_id = oi.organization_id
255: AND ou.location_id = loc.location_id