DBA Data[Home] [Help]

APPS.ORACLENAVIGATE dependencies on FND_SECURITY_GROUPS_VL

Line 535: from FND_SECURITY_GROUPS_VL fsg,

531: a.DESCRIPTION,
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

Line 812: from FND_SECURITY_GROUPS_VL fsg,

808: l_security_group_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

Line 1221: from FND_SECURITY_GROUPS_VL fsg,

1217: fa.application_short_name,
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

Line 1797: from FND_SECURITY_GROUPS_VL fsg,

1793: a.responsibility_name,
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