DBA Data[Home] [Help]

APPS.FND_FUNCTION_SECURITY dependencies on FND_MENUS_S

Line 104: FROM fnd_menu_entries me, fnd_menus m, fnd_menus s, fnd_form_functions f

100: dummy NUMBER;
101: BEGIN
102: SELECT 1
103: INTO dummy
104: FROM fnd_menu_entries me, fnd_menus m, fnd_menus s, fnd_form_functions f
105: WHERE me.menu_id = m.menu_id
106: AND m.menu_name = menu_entry_exists.menu_name
107: AND me.sub_menu_id = s.menu_id (+)
108: AND nvl(s.menu_name, 'x') = nvl(menu_entry_exists.sub_menu_name, 'x')

Line 780: SELECT fnd_menus_s.NEXTVAL

776:
777: -- Select to decide if this is insert or update
778: IF (menu_id = -1) THEN
779:
780: SELECT fnd_menus_s.NEXTVAL
781: INTO menu.menu_id
782: FROM dual;
783:
784: -- Insert into base