LOV_STACKED CANVAS

LOV_STACKED CANVAS:

empno contains lov in content canvas which executes the employee details in the stacked canvas.
    declare a variable and assign the value for tat variable from the database table then set the assigned value to the output field name
 
Tables:
empp(empno number,ename varchar2(20),comm number)
employe(e_id number,first_name varchar2(20),last_name varchar2(20),
   dob date,mobile_no number,salary number,dept_id number)

QUERY:

DECLARE
  e_id employe.e_id%type;
  e_id1 employe.e_id%type;
    fname employe.first_name%type;
    lname employe.last_name%type;
    d_date employe.dob%type;
    mobile employe.mobile_no%type;
    sal employe.salary%type;
    d_id employe.dept_id%type;
begin
    select e_id,first_name,last_name,dob,mobile_no,salary,dept_id into
e_id1,fname,lname,d_date,mobile,sal,d_id from employe
    where :empp.empno=employe.e_id;
    :employe.e_id:=e_id1;
    :employe.first_name:=fname;
    :employe.last_name:=lname;
    :employe.dob:=d_date;
    :employe.mobile_no:=mobile;
   :employe.salary:=sal;
    :employe.dept_id:=d_id;
END;