responsibilities assigned to user

---------------------------Responsibility attached to a user---------------------------
 SELECT DISTINCT
          fu.user_name "User Name"
        , frt.responsibility_name "Responsibility Name"
        , fr.responsibility_key "Responsibility Key"
        , fa.application_short_name "Application Short Name"
 FROM
          fnd_user_resp_groups_direct   furg
        , applsys.fnd_user              fu
        , applsys.fnd_responsibility_tl frt
        , applsys.fnd_responsibility    fr
        , applsys.fnd_application_tl    fat
        , applsys.fnd_application       fa
 WHERE
          furg.user_id               = fu.user_id
          AND furg.responsibility_id = frt.responsibility_id
          AND fr.responsibility_id   = frt.responsibility_id
          AND fa.application_id      = fat.application_id
          AND fr.application_id      = fat.application_id
          AND frt.language           = USERENV('LANG')
          AND UPPER(fu.user_name)    = UPPER('sreeram.g') -- 
 ORDER BY
          2
 ;
 
 /
 --------------------------- User attached to a specific Responsibility ---------------------------
 /
 SELECT distinct
        usr.user_id
      , usr.user_name
      , (
               select distinct
                      ppf.full_name
               from
                      per_all_people_F PPF
               where
                      usr.employee_id=ppf.person_id
        )
        Full_Name
      , res.RESPONSIBILITY_ID
      , res.RESPONSIBILITY_NAME
 FROM
        apps.FND_USER              usr
      , apps.FND_RESPONSIBILITY_TL res
      , apps.FND_USER_RESP_GROUPS  grp
 WHERE
        upper(res.RESPONSIBILITY_NAME)         LIKE upper('%'|| NVL('&EnterRespName', 'INV')|| '%')
        AND upper(res.RESPONSIBILITY_NAME) NOT LIKE '%AX%'
        AND upper(res.RESPONSIBILITY_NAME) NOT LIKE '%OPM%'
        AND grp.responsibility_id                 = res.responsibility_id
        AND grp.user_id                           = usr.user_id
 ;