SELECT frv.responsibility_name name, frv.start_date, frv.end_date
  FROM apps.fnd_user_resp_groups furg,
       apps.fnd_responsibility_vl frv,
       apps.fnd_user fu
 WHERE furg.user_id = fu.user_id
   AND fu.user_id = (SELECT user_id
                      FROM fnd_user
                     WHERE user_name = UPPER(:p_user_name))
   AND furg.responsibility_id = frv.responsibility_id
   AND furg.responsibility_application_id = frv.application_id

Share on Facebook