Query to get all profile options which are recently changed.

--Query to get all profile options which are recently changed.
SELECT DISTINCT p.profile_option_name SHORT_NAME
      ,n.user_profile_option_name "PROFILE NAME"
      ,DECODE(v.level_id, 10001, 'Site Level',
              10002, 'Application Level',
              10003, 'Responsibility Level',
              10004, 'User Level',
              10005, 'Server Level',
              10007, 'SERVRESP',
              'UnDef') LEVEL_SET
      ,DECODE(TO_CHAR(v.level_id), '10001', '',
              '10002', app.application_short_name,
              '10003', rsp.responsibility_key,
              '10005', svr.node_name,
              '10006', org.name,
              '10004', usr.user_name,
              '10007', 'Serv/resp',
              'UnDef') "CONTEXT"
       ,v.profile_option_value VALUE
       ,v.LAST_UPDATE_DATE
   FROM fnd_profile_options p
       ,fnd_profile_option_values v
       ,fnd_profile_options_tl n
       ,fnd_application app
       ,fnd_responsibility rsp
       ,fnd_nodes svr
       ,hr_operating_units org
       ,fnd_user usr
  WHERE p.profile_option_id = v.profile_option_id (+)
    and p.profile_option_name = n.profile_option_name
    and usr.user_id (+) = v.level_value
    and rsp.application_id (+) = v.level_value_application_id
    and rsp.responsibility_id (+) = v.level_value
    and app.application_id (+) = v.level_value
    and svr.node_id (+) = v.level_value
    and org.organization_id (+) = v.level_value
    and v.LAST_UPDATE_DATE is not null
    --and upper(n.user_profile_option_name) like upper('BNE%')
    and trunc(v.LAST_UPDATE_DATE) between trunc(sysdate-10) AND trunc(sysdate)
 ORDER BY last_update_date desc
         ,short_name, level_set;