Query to get Site level and Organization level Profile Option Value

1--Site level profile option value
2  SELECT USER_PROFILE_OPTION_NAME, fpov.profile_option_value
3    FROM fnd_profile_option_values fpov, fnd_profile_options_vl fpo
4   WHERE     fpov.profile_option_id(+) = fpo.profile_option_id
5         AND USER_PROFILE_OPTION_NAME IN
6                ('CSE: Debug Log Directory',
7                 'CSE: Debug Option',
8                 'CSI: Contracts Enabled')             ---Profile Option Names
9         AND fpov.level_value(+) = '0'
10ORDER BY 1;

1--Organization level profile option value
2  SELECT NAME,
3         (SELECT fpov.profile_option_value
4            FROM fnd_profile_option_values fpov, fnd_profile_options_vl fpo
5           WHERE     fpov.profile_option_id = fpo.profile_option_id
6                 AND USER_PROFILE_OPTION_NAME = 'CSE: FA Book Type Code'
7                 AND fpov.level_value = ORGANIZATION_ID)
8            profile_option_value
9    FROM hr_operating_units
10   WHERE NAME = 'Your Operating Unit Name'
11ORDER BY 1;