select user_guid from apps.fnd_user
where user_guid is not null;
If the result is 0 rows, then your instance is not enabled for SSO.
If the result is > 0 rows, then your instance is SSO enabled.
The other obvious way is to try to login to the instance. If you are presented with the SSO screen for username/password, then you are SSO enabled.