ACS3 Data Model

     1: function im_supervises_p(v_supervisor_id IN integer, v_user_id IN integer)
     2: return varchar
     3: is
     4:   v_exists_p char;
     5: BEGIN
     6:   select decode(count(1),0,'f','t') into v_exists_p
     7:    from im_employee_info
     8:    where user_id = v_user_id
     9:    and level > 1
    10:    start with user_id = v_supervisor_id
    11:    connect by supervisor_id = PRIOR user_id;
    12:    return v_exists_p;
    13: END im_supervises_p;