APPS.JTF_MENU_PUB dependencies on FND_MENUS_VL

Line 260: --from fnd_menus_vl a , fnd_responsibility b

256: -- here's the old cursor definition, which assumed userenv('lang')
257: -- was set correctly:
258: -- cursor root_menu(pp_respid number, pp_appid number) is
259: --select a.menu_id, a.menu_name , a.user_menu_name, a.description
260: --from fnd_menus_vl a , fnd_responsibility b
261: --where a.menu_id = b.menu_id and b.responsibility_id = pp_respid
262: --and b.application_id = pp_appid;
263:
264: -- here's the new one, which assumes we use pp_lang instead

Line 332: from fnd_menus_vl a , fnd_responsibility b

328: cnt number := 0;
329: l_resp_name varchar2(256);
330: cursor root_menu(pp_respid number, pp_appid number) is
331: select a.menu_id, a.menu_name , a.user_menu_name, a.description
332: from fnd_menus_vl a , fnd_responsibility b
333: where a.menu_id = b.menu_id and b.responsibility_id = pp_respid
334: and b.application_id = pp_appid;
335:
336: --cursor get_responsibilities(pp_menuid number) is

Line 711: -- from fnd_menus_vl

707: l_prompt_name varchar2(80);
708: -- here's the query, before we parameterized it by language
709: -- cursor get_root_name(p_menu_id number) is
710: -- select user_menu_name
711: -- from fnd_menus_vl
712: -- where menu_id = p_menu_id;
713: cursor get_root_name(p_menu_id number, pp_lang varchar2) is
714: SELECT T.USER_MENU_NAME
715: FROM FND_MENUS_TL T, FND_MENUS B

Line 734: from fnd_menus_vl

730: l_prompt_name varchar2(80);
731:
732: cursor get_root_name(p_menu_id number) is
733: select user_menu_name
734: from fnd_menus_vl
735: where menu_id = p_menu_id;
736:
737: BEGIN
738: open get_root_name(p_menu_id);