APPS.UMX_W3H_UTL dependencies on FND_COMPILED_MENU_FUNCTIONS

Line 31: from fnd_form_functions frm,fnd_compiled_menu_functions fcm,fnd_menus fm

27: l_list varchar2(3200);
28:
29: cursor function_list IS
30: select frm.function_name
31: from fnd_form_functions frm,fnd_compiled_menu_functions fcm,fnd_menus fm
32: where frm.function_id=fcm.function_id
33: and fcm.menu_id=fm.menu_id
34: and fm.menu_name=l_menu_name;
35:

Line 156: or (frf.rule_type='M' and frm.function_id in (select fcm.function_id from fnd_compiled_menu_functions fcm

152: where wur.name = roles.roleName
153: and fr.responsibility_key = substr(wur.name,instr(wur.name,'|',1,2)+1,(instr(wur.name,'|',1,3)-1-instr(wur.name,'|',1,2)))
154: and frf.responsibility_id=fr.responsibility_id
155: and ((frf.rule_type='F' and frf.action_id = frm.function_id)
156: or (frf.rule_type='M' and frm.function_id in (select fcm.function_id from fnd_compiled_menu_functions fcm
157: where fcm.menu_id=frf.action_id)
158: ));
159:
160: func varchar2(1000); /*temp var to store thevalues fetched from the cursor*/