To find the responsibilty for which form was assigned

SELECT fu.user_name, fu.description, furg.start_date,

frvl.responsibility_name, fff.function_name, ff.form_name

FROM fnd_user fu,

fnd_user_resp_groups furg,

fnd_responsibility_vl frvl,

fnd_compiled_menu_functions fcmf,

fnd_form_functions_vl fff,

fnd_form_vl ff

WHERE fu.user_id = furg.user_id

AND furg.responsibility_id = frvl.responsibility_id

AND frvl.menu_id = fcmf.menu_id

AND fff.function_id = fcmf.function_id

AND fff.form_id = ff.form_id

AND (fu.end_date IS NULL OR fu.end_date >= SYSDATE)

AND (furg.end_date IS NULL OR furg.end_date >= SYSDATE)

AND (frvl.end_date IS NULL OR frvl.end_date >= SYSDATE)

AND form_name IN ('FORMNAME');