APPS.FND_FUNCTION dependencies on FND_MENUS

Line 1921: select /*+ INDEX_FFS(menus) */ menu_id from fnd_menus menus

1917: last_index pls_integer;
1918:
1919: /* Bug 5196541. Added sql hints to improve the performance */
1920: cursor get_missing_menus_c is
1921: select /*+ INDEX_FFS(menus) */ menu_id from fnd_menus menus
1922: where not exists
1923: (select /*+ PARALLEL(cmf) */ 'X'
1924: from fnd_compiled_menu_functions cmf
1925: where menus.menu_id = cmf.menu_id);

Line 2550: -- for each menu_id in fnd_menus

2546:
2547: -- MARK_ALL_I-
2548: --
2549: -- truncate compiled table.
2550: -- for each menu_id in fnd_menus
2551: -- Mark that menu_id in the compiled table
2552: --
2553: --
2554: procedure MARK_ALL_I is

Line 2559: select menu_id from fnd_menus;

2555: l_api_name CONSTANT VARCHAR2(30) := 'MARK_ALL';
2556: l_menu_id number;
2557:
2558: cursor get_all_menus_c is
2559: select menu_id from fnd_menus;
2560:
2561: last_index pls_integer;
2562:
2563: TYPE NUMBER_TABLE_TYPE is table of NUMBER INDEX BY BINARY_INTEGER;

Line 2666: -- for each menu_id in fnd_menus

2662:
2663: -- MARK_ALL-
2664: --
2665: -- truncate compiled table.
2666: -- for each menu_id in fnd_menus
2667: -- Mark that menu_id in the compiled table
2668: --
2669: --
2670: procedure MARK_ALL is