DBA Data[Home] [Help]

APPS.BIS_FND_MENUS_PUB dependencies on FND_MENUS_VL

Line 43: from fnd_menus_vl

39:
40: begin
41: select menu_name, user_menu_name
42: into l_menu_name, l_user_menu_name
43: from fnd_menus_vl
44: where menu_name = p_menu_name
45: or user_menu_name = p_user_menu_name;
46: exception
47: when others then null;

Line 126: from fnd_menus_vl

122: select menu_name,
123: type,
124: user_menu_name,
125: description
126: from fnd_menus_vl
127: where menu_id = p_MENU_ID;
128:
129: l_count NUMBER;
130: begin

Line 150: from fnd_menus_vl

146: l_fnd_menu_rec.user_menu_name := p_user_menu_name;
147:
148: select count(1)
149: into l_count
150: from fnd_menus_vl
151: where menu_id <> p_menu_id
152: and user_menu_name = p_user_menu_name;
153:
154: if l_count > 0 then

Line 220: from fnd_menus_vl m, fnd_menu_entries_vl me

216: ) IS
217:
218: cursor cr_menu_usage is
219: select m.user_menu_name
220: from fnd_menus_vl m, fnd_menu_entries_vl me
221: where sub_menu_id = p_menu_id
222: and me.menu_id = m.menu_id;
223:
224: cursor cr_resp_usage is