Query the values set for a profiles – in this instance DOO

-- 
select
    p.profile_option_name
  , l.level_name
  , v.level_value
  , l.enabled_flag
  , v.profile_option_value
from
    fnd_profile_option_values v
  , fnd_profile_options_b     p
  , FND_PROFILE_OPTION_LEVELS l
where
    p.profile_option_id  = l.profile_option_id
    and p.application_id = l.application_id
    and
    -- l.enabled_flag = 'Y' and
    l.profile_option_id          = v.profile_option_id
    and l.application_id         = v.application_id
    and l.level_name             = v.level_name
    and p.profile_option_name like 'DOO%'