APPS.ORACLEAPPS dependencies on FND_RESPONSIBILITY

Line 1149: from fnd_responsibility fr,

1145:
1146: cursor getResp(p_user_id in varchar2) is
1147: select fr.menu_id, furg.responsibility_id,
1148: furg.security_group_id, furg.responsibility_application_id
1149: from fnd_responsibility fr,
1150: fnd_user_resp_groups furg,
1151: fnd_user fu
1152: where fu.USER_ID = p_user_id
1153: and fu.START_DATE <= sysdate

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 2636: from fnd_responsibility

2632: if ((l_responsibility_id is not NULL) AND (l_resp_appl_id is not null))
2633: then
2634: select web_host_name, web_agent_name
2635: into l_resp_web_host, l_resp_web_agent
2636: from fnd_responsibility
2637: where responsibility_id = nvl(p_responsibility_id,l_responsibility_id) -- Bug 2726022
2638: and application_id = nvl(p_resp_appl_id,l_resp_appl_id); -- Bug 2160456
2639: else
2640: l_resp_web_host := '';

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