DBA Data[Home] [Help]

APPS.ORACLEPLUGS dependencies on FND_RESPONSIBILITY

Line 343: fnd_responsibility_vl a,

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
347: and (b.end_date is null or b.end_date > sysdate)

Line 372: fnd_responsibility_vl a,

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
376: and (b.end_date is null or b.end_date > sysdate)

Line 392: from fnd_responsibility e,

388: select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
389: b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
390: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
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

Line 427: from fnd_responsibility e,

423: select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
424: b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
425: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
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