367: menu_id
368: into l_responsibility_name,
369: l_description,
370: l_menu_id
371: from fnd_responsibility_vl
372: where application_id = p_object.resp_appl_id
373: and responsibility_id = p_object.responsibility_id
374: and version in ('4','W')
375: and start_date <= sysdate
532: fsg.SECURITY_GROUP_NAME,
533: m.TYPE,
534: m.menu_id
535: from FND_SECURITY_GROUPS_VL fsg,
536: FND_RESPONSIBILITY_VL a,
537: FND_USER_RESP_GROUPS b,
538: fnd_menus m
539: where b.user_id = icx_sec.g_user_id
540: AND a.menu_id = m.menu_id
809: l_responsibility_name,
810: l_responsibility_description,
811: l_security_group_name
812: from FND_SECURITY_GROUPS_VL fsg,
813: FND_RESPONSIBILITY_VL a,
814: FND_USER_RESP_GROUPS b
815: where b.USER_ID = icx_sec.g_user_id
816: and a.APPLICATION_ID = b.RESPONSIBILITY_APPLICATION_ID
817: and a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
1218: m.menu_id,
1219: m.type,
1220: a.version
1221: from FND_SECURITY_GROUPS_VL fsg,
1222: fnd_responsibility_vl a,
1223: FND_USER_RESP_GROUPS b,
1224: FND_APPLICATION fa,
1225: FND_MENUS m
1226: where b.user_id = icx_sec.g_user_id
1794: a.application_id,
1795: b.security_group_id,
1796: fsg.SECURITY_GROUP_NAME
1797: from FND_SECURITY_GROUPS_VL fsg,
1798: fnd_responsibility_vl a,
1799: FND_USER_RESP_GROUPS b
1800: where b.user_id = icx_sec.g_user_id
1801: and b.start_date <= sysdate
1802: and (b.end_date is null or b.end_date > sysdate)