APPS.IRC_PARTY_SWI dependencies on FND_MENUS

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

1239: --
1240: cursor get_homepage is
1241: select fe.menu_id
1242: from fnd_menu_entries fe
1243: where 'HOMEPAGE'=(select fm.type from fnd_menus fm
1244: where fm.menu_id=fe.menu_id)
1245: start with fe.menu_id=
1246: (select resp.menu_id from fnd_responsibility resp
1247: where resp.responsibility_key=p_responsibility_key)

Line 1254: from fnd_menus fm

1250: order by level,fe.entry_sequence;
1251: --
1252: cursor get_menu_info(p_menu_id number) is
1253: select fm.menu_name
1254: from fnd_menus fm
1255: where fm.menu_id=p_menu_id;
1256: --
1257: l_function_id fnd_menu_entries.function_id%type;
1258: l_function_name fnd_form_functions.function_name%type;

Line 1260: l_menu_name fnd_menus.menu_name%type;

1256: --
1257: l_function_id fnd_menu_entries.function_id%type;
1258: l_function_name fnd_form_functions.function_name%type;
1259: l_menu_id fnd_menu_entries.menu_id%type;
1260: l_menu_name fnd_menus.menu_name%type;
1261: --
1262: begin
1263: open get_function_id;
1264: fetch get_function_id into l_function_id;