DBA Data[Home] [Help]

APPS.ORACLENAVIGATE dependencies on FND_RESPONSIBILITY_VL

Line 371: from fnd_responsibility_vl

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

Line 536: FND_RESPONSIBILITY_VL a,

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

Line 813: FND_RESPONSIBILITY_VL a,

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

Line 1222: fnd_responsibility_vl a,

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

Line 1798: fnd_responsibility_vl a,

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)