Thanks to Emrah Mete
When writing queries in database versions, we couldn’t use correlated subqueries in the FROM section of our query. With Oracle 12c, this is addressed.
https://dzone.com/articles/a-different-approach-to-subqueries-with-oracle-12c

SELECT *
FROM hr.employees e,
LATERAL
(SELECT * FROM hr.departments WHERE department_id = e.department_id) x
WHERE x.department_name =’Public Relations’;

SELECT *
FROM hr.employees e
CROSS APPLY
(SELECT * FROM hr.departments WHERE department_id = e.department_id) x;

SELECT *
FROM hr.employees e
OUTER APPLY
(SELECT * FROM hr.departments WHERE department_id = e.department_id) x;