DBA Data[Home] [Help]

APPS.ZX_MIGRATE_UTIL dependencies on HR_ORGANIZATION_INFORMATION

Line 237: hr_organization_information oi,

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

Line 249: hr_organization_information oi,

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