What tables can be used to relate fnd_responsibility_vl and FND_USER

[wrwelden]

What tables can be used to relate fnd_responsibility_vl and FND_USER

[PAVB]

you can just google it, plenty of stuff out there like...

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

... which retrieves responsibilities for a specific user.