To find supervisor of the user and the authorization limit of the user and supervisor

For 11.5.0

SELECT   a.user_name user_id,
         b.full_name user_full_name,
         c.d_supervisor_id supervisor_user_id,
         d.authorization_limit User_auth_limit,
         e.authorization_limit Supervisor_auth_limit,
         e.set_of_books_id,
         (SELECT   name
            FROM   gl_sets_of_books
           WHERE   set_of_books_id = e.set_of_books_id)
            SOB_NAME
  FROM   fnd_user a,
         per_all_people_f b,
         PER_ASSIGNMENTS_V7 c,
         gl_authorization_limits_v d,
         gl_authorization_limits_v e
 WHERE       a.employee_id = b.person_id
         AND b.person_id = c.person_id(+)
         AND a.employee_id = d.employee_id(+)
         AND c.supervisor_id = e.employee_id(+)
         AND a.user_name = '&preparer name';

For R12

SELECT   a.user_name user_id,
         b.full_name user_full_name,
         c.d_supervisor_id supervisor_user_id,
         d.authorization_limit User_auth_limit,
         e.authorization_limit Supervisor_auth_limit,
         e.set_of_books_id,
         (SELECT   name
            FROM   gl_sets_of_books
           WHERE   set_of_books_id = e.set_of_books_id)
            SOB_NAME
  FROM   fnd_user a,
         per_all_people_f b,
         PER_ASSIGNMENTS_V7 c,
         gl_authorization_limits_v d,
         gl_authorization_limits_v e
 WHERE       a.employee_id = b.person_id
         AND b.person_id = c.person_id(+)
         AND a.employee_id = d.employee_id(+)
         AND c.supervisor_id = e.employee_id(+)
         AND a.user_name = '&preparar name';