12: fr.APPLICATION_ID,
13: fr.RESPONSIBILITY_ID,
14: furg.SECURITY_GROUP_ID
15: from FND_MENU_ENTRIES fme,
16: FND_RESPONSIBILITY_VL fr,
17: FND_USER_RESP_GROUPS furg
18: where furg.USER_ID = icx_sec.g_user_id
19: and furg.RESPONSIBILITY_APPLICATION_ID = fr.APPLICATION_ID
20: and furg.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID
461: WHERE application_short_name = p_application_short_name;
462:
463: SELECT responsibility_id
464: INTO l_responsibility_id
465: FROM fnd_responsibility
466: WHERE responsibility_key = p_responsibility_key
467: AND application_id = l_application_id;
468:
469: SELECT function_id