DBA Data[Home] [Help]

APPS.ZX_MIGRATE_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 236: FROM hr_all_organization_units ou,

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

Line 248: FROM hr_all_organization_units ou,

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