في خطأ في الكود اتمنى اعرف ليش (هو ما بنفذ بعد الelse)انا كثير مستعجل

FUNCTION CAL_EMP_SAL (num in integer,v_employee_id in employees.employee_id%type)
return number
is
v_manager_id employees.manager_id%type;
sal number := 0;
begin 

select distinct(nvl(manager_id,0))
into v_manager_id
from employees
where manager_id=v_employee_id;

if (v_manager_id=v_employee_id)
then
select (salary+nvl(commission_pct,0)+num)-salary*0.16
into sal
from employees 
where employee_id=v_employee_id;
else 
select (salary+nvl(commission_pct,0))-salary*0.16 
into sal
from employees 
where employee_id=v_employee_id;
end if;
return sal;
end;

شكراً اذا في حدى دخل بس المشكلة انحلت