DBA Data[Home] [Help]

APPS.ORACLEAPPS dependencies on FND_USER_RESP_GROUPS

Line 1150: fnd_user_resp_groups furg,

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
1154: and (fu.END_DATE is null or fu.END_DATE > sysdate)

Line 1463: FND_USER_RESP_GROUPS b

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
1467: and a.version = 'W'

Line 2982: FND_USER_RESP_GROUPS b,

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
2986: and a.version = 'W'