select 
"EMPNO",
"DEPTNO",
"ENAME",
"JOB",
"HIREDATE",
"SAL",
"WORK_CITY",
"WORK_COUNTRY"
from "#OWNER#"."WWV_DEMO_EMP"
where "DEPTNO" = :P27_DEPTNO