Obtain responsibility for a user

SELECT SUBSTR(user_name,1,15) AS username,

b.responsibility_key,

b.responsibility_name name, TO_CHAR(a.responsibility_id) id

FROM fnd_user_resp_groups a,

fnd_responsibility_vl b,

fnd_user u

WHERE a.user_id = u.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 UPPER(u.user_name) LIKE UPPER('&username%')