APPS.IRC_PARTY_SWI dependencies on FND_MENUS

Line 1231: where 'HOMEPAGE'=(select fm.type from fnd_menus fm

1227: --
1228: cursor get_homepage is
1229: select fe.menu_id
1230: from fnd_menu_entries fe
1231: where 'HOMEPAGE'=(select fm.type from fnd_menus fm
1232: where fm.menu_id=fe.menu_id)
1233: start with fe.menu_id=
1234: (select resp.menu_id from fnd_responsibility resp
1235: where resp.responsibility_key=p_responsibility_key)

Line 1242: from fnd_menus fm

1238: order by level,fe.entry_sequence;
1239: --
1240: cursor get_menu_info(p_menu_id number) is
1241: select fm.menu_name
1242: from fnd_menus fm
1243: where fm.menu_id=p_menu_id;
1244: --
1245: l_function_id fnd_menu_entries.function_id%type;
1246: l_function_name fnd_form_functions.function_name%type;

Line 1248: l_menu_name fnd_menus.menu_name%type;

1244: --
1245: l_function_id fnd_menu_entries.function_id%type;
1246: l_function_name fnd_form_functions.function_name%type;
1247: l_menu_id fnd_menu_entries.menu_id%type;
1248: l_menu_name fnd_menus.menu_name%type;
1249: --
1250: begin
1251: open get_function_id;
1252: fetch get_function_id into l_function_id;