VARIABLE user_name VARCHAR2(100)
EXEC :user_name := 'PARABOL64';
SELECT fu.user_name
,      frv.responsibility_name
FROM   apps.fnd_responsibility_vl       frv
,      applsys.fnd_request_groups       frg
,      apps.fnd_user_resp_groups_all    furga
,      applsys.fnd_user                 fu
WHERE  fu.user_name            = :user_name
AND    TRUNC(SYSDATE) BETWEEN fu.start_date
                          AND NVL(fu.end_date
                              ,   TO_DATE('31-DEC-4712'
                                  ,       'DD-MON-YYYY'))
AND    fu.user_id              = furga.user_id
AND    TRUNC(SYSDATE) BETWEEN furga.start_date
                          AND NVL(furga.end_date
                              ,   TO_DATE('31-DEC-4712'
                                  ,       'DD-MON-YYYY'))
AND    furga.responsibility_id = frv.responsibility_id
AND    frv.request_group_id    = frg.request_group_id
/

SELECT b.responsibility_name NAME
  FROM apps.fnd_user_resp_groups a,
       apps.fnd_responsibility_vl b,
       apps.fnd_user u
 WHERE a.user_id = u.user_id
   AND u.user_id = &p_user_id
   AND a.responsibility_id = b.responsibility_id
   AND a.responsibility_application_id = b.application_id
   AND SYSDATE BETWEEN a.start_date AND NVL (a.end_date, SYSDATE + 1)
   AND b.end_date IS NULL
   AND u.end_date IS NULL