DBA Data[Home] [Help]

APPS.HR_HELPDESK_UTIL_SS dependencies on FND_RESPONSIBILITY

Line 136: FROM fnd_responsibility

132: (SELECT fme.function_id,
133: fme.menu_id
134: FROM fnd_menu_entries fme START WITH fme.menu_id IN
135: (SELECT menu_id
136: FROM fnd_responsibility
137: WHERE responsibility_id IN
138: (SELECT responsibility_id
139: FROM fnd_user_resp_groups
140: WHERE user_id = fnd_global.user_id)

Line 159: FROM fnd_responsibility

155: (SELECT fme.function_id,
156: fme.menu_id
157: FROM fnd_menu_entries fme START WITH fme.menu_id IN
158: (SELECT menu_id
159: FROM fnd_responsibility
160: WHERE responsibility_id IN
161: (SELECT responsibility_id
162: FROM fnd_user_resp_groups
163: WHERE user_id = fnd_global.user_id

Line 222: l_resp_name fnd_responsibility.RESPONSIBILITY_KEY%type;

218: FUNCTION get_resp_name(func_name fnd_form_functions.function_name%type,
219: bus_grp_id per_all_people_f.business_group_id%type)
220: RETURN VARCHAR2 IS
221:
222: l_resp_name fnd_responsibility.RESPONSIBILITY_KEY%type;
223:
224: BEGIN
225:
226: SELECT responsibility_key

Line 228: FROM fnd_responsibility

224: BEGIN
225:
226: SELECT responsibility_key
227: INTO l_resp_name
228: FROM fnd_responsibility
229: WHERE menu_id IN
230: (SELECT menu_id
231: FROM fnd_menu_entries fme START WITH fme.function_id =
232: (SELECT function_id