create or replace package hr.pkg_report_emp
is
procedure pro_report(p_dep_id number,out_ref_report out ref_report);
is
begin
open out_ref_report for
select * from EMPLOYEES e,DEPARTMENTS d,LOCATIONS l,JOB_HISTORY h
where e.department_id=d.department_id
and l.location_id=d.location_id
and h.employee_id=e.employee_id
and d.department_id=p_dep_id;
end;
end pkg_report_emp;
/