Find Responsibility Name attached with Profile

SELECT DISTINCT tr.responsibility_name,

  r.RESPONSIBILITY_KEY,
  r.end_date,
  fpotl.user_profile_option_name,
  fpov.profile_option_value,
  psp.SECURITY_PROFILE_NAME
FROM applsys.fnd_responsibility_tl tr,
  applsys.fnd_responsibility r,
  hr.per_security_profiles psp,
  apps.per_business_groups pbg,
  fnd_profile_options_vl fpovl,
  applsys.fnd_profile_option_values fpov,
  applsys.fnd_profile_options fpo,
  applsys.fnd_profile_options_tl fpotl
WHERE r.responsibility_id          = tr.responsibility_id
AND r.application_id               = tr.application_id
AND fpov.PROFILE_OPTION_ID         = fpovl.PROFILE_OPTION_ID
AND fpov.level_value               = r.responsibility_id
AND psp.BUSINESS_GROUP_ID          = pbg.BUSINESS_GROUP_ID (+)
AND fpov.profile_option_value      = TO_CHAR(psp.SECURITY_PROFILE_id)
AND fpov.level_id                  = 10003
AND fpo.profile_option_id          = fpov.profile_option_id
AND fpotl.profile_option_name      = fpo.profile_option_name
AND fpotl.user_profile_option_name = 'HR: Security Profile'
AND psp.security_profile_name      ='US Federal Government';