DBA Data[Home] [Help]

APPS.OTA_TDB_BUS2 dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 985: FROM hr_all_organization_units_tl org,

981: SELECT org.name,
982: org.organization_id,
983: loc.country,
984: loc.location_id
985: FROM hr_all_organization_units_tl org,
986: hr_all_organization_units org1,
987: hr_locations_all loc
988: WHERE org.organization_id = org1.organization_id
989: AND loc.location_id(+) = org1.location_id