APPS.CZ_SECURITY_PVT dependencies on FND_MENUS

Line 109: FROM fnd_menus

105: l_menu_id NUMBER := 0;
106: BEGIN
107: SELECT menu_id
108: INTO l_menu_id
109: FROM fnd_menus
110: WHERE fnd_menus.menu_name = p_menu_name
111: AND fnd_menus.type = SECURITY_MENU;
112: RETURN l_menu_id;
113: EXCEPTION

Line 110: WHERE fnd_menus.menu_name = p_menu_name

106: BEGIN
107: SELECT menu_id
108: INTO l_menu_id
109: FROM fnd_menus
110: WHERE fnd_menus.menu_name = p_menu_name
111: AND fnd_menus.type = SECURITY_MENU;
112: RETURN l_menu_id;
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN

Line 111: AND fnd_menus.type = SECURITY_MENU;

107: SELECT menu_id
108: INTO l_menu_id
109: FROM fnd_menus
110: WHERE fnd_menus.menu_name = p_menu_name
111: AND fnd_menus.type = SECURITY_MENU;
112: RETURN l_menu_id;
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN
115: l_menu_id := 0;

Line 137: FROM fnd_menus

133: WHERE fnd_compiled_menu_functions.function_id IN (SELECT function_id
134: FROM fnd_form_functions
135: WHERE fnd_form_functions.function_name = p_function_name)
136: AND fnd_compiled_menu_functions.menu_id = (SELECT menu_id
137: FROM fnd_menus
138: WHERE fnd_menus.menu_name = p_menu_name);
139: RETURN l_menu_id;
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN

Line 138: WHERE fnd_menus.menu_name = p_menu_name);

134: FROM fnd_form_functions
135: WHERE fnd_form_functions.function_name = p_function_name)
136: AND fnd_compiled_menu_functions.menu_id = (SELECT menu_id
137: FROM fnd_menus
138: WHERE fnd_menus.menu_name = p_menu_name);
139: RETURN l_menu_id;
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN
142: RETURN l_menu_id;