Estou executando o seguinte script -

BEGIN
    select department_name 
    from egpl_department 
    where department_id in (select department_id 
                            from egpl_casemgmt_activity);
END ;

E obteve o erro -

PLS-00103: Encountered the symbol "end-of-file" when 
expecting one of the following: 
;