APPS.ORACLEPLUGS dependencies on FND_MENU_ENTRIES

Line 49: from fnd_menu_entries_vl

45: select prompt,
46: description,
47: sub_menu_id,
48: entry_sequence
49: from fnd_menu_entries_vl
50: where menu_id = p_object.parent_menu_id
51: and sub_menu_id is not null
52: order by entry_sequence;
53:

Line 61: fnd_menu_entries_vl b

57: b.function_id,
58: b.entry_sequence,
59: a.type
60: from fnd_form_functions a,
61: fnd_menu_entries_vl b
62: where b.menu_id = p_object.parent_menu_id
63: and a.function_id = b.function_id
64: and a.type = p_object.function_type
65: order by entry_sequence;

Line 71: from fnd_menu_entries

67: begin
68:
69: select count(*)
70: into l_count
71: from fnd_menu_entries
72: where menu_id = p_object.parent_menu_id
73: and sub_menu_id is not null;
74:
75: if l_count > 0

Line 342: fnd_menu_entries_vl c,

338: c.description,
339: d.function_id,
340: d.type
341: from fnd_form_functions d,
342: fnd_menu_entries_vl c,
343: fnd_responsibility_vl a,
344: FND_USER_RESP_GROUPS b
345: where b.user_id = icx_sec.g_user_id
346: and b.start_date <= sysdate

Line 371: fnd_menu_entries_vl c,

367: c.description,
368: d.function_id,
369: d.type
370: from fnd_form_functions d,
371: fnd_menu_entries_vl c,
372: fnd_responsibility_vl a,
373: FND_USER_RESP_GROUPS b
374: where b.user_id = icx_sec.g_user_id
375: and b.start_date <= sysdate

Line 395: FND_MENU_ENTRIES_VL c,

391: c.DESCRIPTION
392: from fnd_responsibility e,
393: FND_USER_RESP_GROUPS d,
394: FND_FORM_FUNCTIONS a,
395: FND_MENU_ENTRIES_VL c,
396: ICX_PAGE_PLUGS b
397: where b.PAGE_ID = l_page_id
398: and b.MENU_ID = c.MENU_ID
399: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE

Line 430: FND_MENU_ENTRIES_VL c,

426: c.DESCRIPTION
427: from fnd_responsibility e,
428: FND_USER_RESP_GROUPS d,
429: FND_FORM_FUNCTIONS a,
430: FND_MENU_ENTRIES_VL c,
431: ICX_PAGE_PLUGS b
432: where b.PAGE_ID = l_page_id
433: and b.MENU_ID = c.MENU_ID
434: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE

Line 1279: FND_MENU_ENTRIES b

1275: begin
1276: select WEB_HTML_CALL
1277: into l_plsql_call
1278: from FND_FORM_FUNCTIONS a,
1279: FND_MENU_ENTRIES b
1280: where b.MENU_ID = p.MENU_ID
1281: and b.ENTRY_SEQUENCE = p.ENTRY_SEQUENCE
1282: and a.FUNCTION_ID = b.FUNCTION_ID;
1283: exception