DBA Data[Home] [Help]

APPS.QP_SECURITY dependencies on FND_COMPILED_MENU_FUNCTIONS

Line 171: from fnd_compiled_menu_functions cmf

167: -- g.grantee_id = cp_org_id)
168: ) AND
169: g.menu_id IN
170: (select cmf.menu_id
171: from fnd_compiled_menu_functions cmf
172: where cmf.function_id = cp_function_id)
173: AND (G.instance_id = cp_instance_id)
174: AND ( g.end_date IS NULL OR g.end_date >= l_sysdate )
175: AND g.start_date <= l_sysdate;

Line 392: FROM fnd_compiled_menu_functions cmf

388: g.grantee_id = -1)) AND
389: g.object_id = cp_object_id AND
390: g.menu_id IN
391: (SELECT cmf.menu_id
392: FROM fnd_compiled_menu_functions cmf
393: WHERE cmf.function_id = cp_function_id) AND
394: (g.end_date IS NULL OR g.end_date >= l_sysdate) AND
395: g.start_date <= l_sysdate;
396:

Line 418: FROM fnd_compiled_menu_functions cmf

414: g.object_id = cp_object_id AND
415: g.instance_type = cp_instance_type AND
416: g.menu_id IN
417: (SELECT cmf.menu_id
418: FROM fnd_compiled_menu_functions cmf
419: WHERE cmf.function_id = cp_function_id) AND
420: (g.end_date IS NULL OR g.end_date >= l_sysdate) AND
421: g.start_date <= l_sysdate;
422: BEGIN

Line 1136: from fnd_compiled_menu_functions cmf

1132: OR (mo_global.get_access_mode = 'M' and mo_global.check_access(g.grantee_id) = 'Y'))
1133: ) AND
1134: g.menu_id IN
1135: (select cmf.menu_id
1136: from fnd_compiled_menu_functions cmf
1137: where cmf.function_id = cp_function_id)
1138: AND (G.instance_id = cp_instance_id)
1139: AND ( g.end_date IS NULL OR g.end_date >= sysdate )
1140: AND g.start_date <= sysdate;