Assistance Required for Locating Tables and Differentiating Login Methods

I am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database:

 

 

I could Identify some tables that give access to the following details but, seems like the there is no data available when I join them through person_id with the per_users table:

 

- Device Information
- IP Address
- Browser
- Email_id

 

Additionally, I am looking for a method to differentiate whether a user has logged in through Single Sign-On (SSO) or a local login.

 

Let me know if you have any suggestions, thanks