Query to show sql_ids related to SQL Profiles

I have a number 0f SQL Profiles on a database I’m working on and I wanted to know the sql_id of the SQL statements that they relate to.  Here is what I came up with

SQL>select distinct

p.name sql_profile_name,

s.sql_id

from

dba_sql_profiles p,

DBA_HIST_SQLSTAT s

where

p.name=s.sql_profile;