apps profile select

SELECT fr.responsibility_name,

u.user_id,

u.responsibility_id,

u.responsibility_application_id

-- INTO d_user_id, d_resp_id, d_appl_id

FROM fnd_user_resp_groups u, fnd_user f, fnd_responsibility_vl fr

WHERE f.user_id = u.user_id

AND user_name LIKE 'KURULUM'

AND u.responsibility_id = fr.responsibility_id