DBA Data[Home] [Help]

APPS.ZX_MIGRATE_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 238: FROM hr_all_organization_units ou,

234: SELECT substr(loc.country,1,2),
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

Line 250: FROM hr_all_organization_units ou,

246: SELECT substr(loc.country,1,2),
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