DBA Data[Home] [Help]

APPS.UMX_W3H_UTL dependencies on FND_RESPONSIBILITY

Line 143: from fnd_responsibility fr,fnd_resp_functions frf, wf_local_roles wur,fnd_form_functions frm,

139: FUNCTION get_excluded_function_list(p_resp_name WF_ROLES.NAME%TYPE) RETURN VARCHAR2 IS
140: /*cursor to gte all the functions excluded for a given reponsibility hierarchy*/
141: CURSOR func_list IS
142: select distinct wur.name||frm.function_name
143: from fnd_responsibility fr,fnd_resp_functions frf, wf_local_roles wur,fnd_form_functions frm,
144: (select wur1.name roleName from wf_local_roles wur1
145: where wur1.name = p_resp_name
146: union
147: select super_name roleName from wf_role_hierarchies