APPS.HR_HELPDESK_UTIL_SS dependencies on FND_RESPONSIBILITY

Line 124: (select menu_id from fnd_responsibility where responsibility_id in(

120:
121: select count(function_id) into l_count from (
122: select fme.function_id,fme.menu_id from fnd_menu_entries fme
123: start with fme.menu_id IN
124: (select menu_id from fnd_responsibility where responsibility_id in(
125: select responsibility_id from fnd_user_resp_groups
126: where user_id = fnd_global.USER_ID))
127: connect by fme.menu_id = prior fme.sub_menu_id )
128: where function_id IN (select function_id from fnd_form_functions

Line 164: FUNCTION get_resp_name(resp_id IN fnd_responsibility.RESPONSIBILITY_ID%type)

160: return 'E';
161:
162: End get_function_type;
163:
164: FUNCTION get_resp_name(resp_id IN fnd_responsibility.RESPONSIBILITY_ID%type)
165: RETURN VARCHAR2 IS
166:
167: l_resp_name fnd_responsibility.RESPONSIBILITY_KEY%type;
168: BEGIN

Line 167: l_resp_name fnd_responsibility.RESPONSIBILITY_KEY%type;

163:
164: FUNCTION get_resp_name(resp_id IN fnd_responsibility.RESPONSIBILITY_ID%type)
165: RETURN VARCHAR2 IS
166:
167: l_resp_name fnd_responsibility.RESPONSIBILITY_KEY%type;
168: BEGIN
169:
170: SELECT responsibility_key
171: INTO l_resp_name

Line 172: FROM fnd_responsibility

168: BEGIN
169:
170: SELECT responsibility_key
171: INTO l_resp_name
172: FROM fnd_responsibility
173: WHERE application_id = 800
174: AND responsibility_id = resp_id;
175:
176: RETURN l_resp_name;