Validation for Sales Person

      SELECT rs.salesrep_id
      from apps.per_all_people_f ppf,
           apps.RA_SALESREPS_ALL rs
     WHERE ppf.person_id =rs.person_id
     AND  UPPER (ppf.full_name) = UPPER (p_sales_person);