APPS.JTF_MENU_PUB dependencies on FND_MENUS_TL

Line 198: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r

194: cnt number := 0;
195: l_resp_name varchar2(256);
196: cursor root_menu(pp_respid number, pp_appid number, pp_lang varchar2) is
197: select b.menu_id, b.menu_name , t.user_menu_name, t.description
198: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
199: where b.menu_id = t.menu_id and
200: t.language = pp_lang and
201: b.menu_id = r.menu_id and
202: r.responsibility_id = pp_respid and

Line 267: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r

263:
264: -- here's the new one, which assumes we use pp_lang instead
265: cursor root_menu(pp_respid number, pp_appid number, pp_lang varchar2) is
266: select b.menu_id, b.menu_name , t.user_menu_name, t.description
267: from fnd_menus_tl t, fnd_menus b, fnd_responsibility r
268: where b.menu_id = t.menu_id and
269: t.language = pp_lang and
270: b.menu_id = r.menu_id and
271: r.responsibility_id = pp_respid and

Line 715: FROM FND_MENUS_TL T, FND_MENUS B

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
716: WHERE B.MENU_ID = T.MENU_ID AND T.LANGUAGE = pp_lang and
717: b.menu_id = p_menu_id;
718: begin
719: open get_root_name(p_menu_id, t_lang);