DBA Data[Home] [Help]

APPS.ORACLEAPPS dependencies on FND_RESPONSIBILITY_VL

Line 1462: from fnd_responsibility_vl a,

1458: a.web_host_name,
1459: a.web_agent_name,
1460: a.version,
1461: a.menu_id
1462: from fnd_responsibility_vl a,
1463: FND_USER_RESP_GROUPS b
1464: where b.user_id = c_user_id
1465: and a.responsibility_id = b.responsibility_id
1466: and a.application_id = b.RESPONSIBILITY_application_id

Line 1968: from fnd_responsibility_vl

1964: then
1965: -- get responsibilty name if root menu
1966: select RESPONSIBILITY_NAME, DESCRIPTION
1967: into l_menu_name, l_menu_description
1968: from fnd_responsibility_vl
1969: where RESPONSIBILITY_ID = l_responsibility_id;
1970: else
1971: -- get the user menu name for the given menu id
1972: select PROMPT, DESCRIPTION

Line 2981: from fnd_responsibility_vl a,

2977:
2978: cursor resps is
2979: select a.responsibility_id,a.responsibility_name,
2980: web_HOST_NAME,web_AGENT_NAME
2981: from fnd_responsibility_vl a,
2982: FND_USER_RESP_GROUPS b,
2983: icx_sessions c
2984: where n_session_id = c.session_id
2985: and c.user_id = b.user_id