APPS.ORACLEPLUGS dependencies on FND_USER_RESP_GROUPS

Line 344: FND_USER_RESP_GROUPS b

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)
348: and b.RESPONSIBILITY_application_id = a.application_id

Line 373: FND_USER_RESP_GROUPS b

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)
377: and b.RESPONSIBILITY_application_id = a.application_id

Line 393: FND_USER_RESP_GROUPS d,

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
397: where b.PAGE_ID = l_page_id

Line 428: FND_USER_RESP_GROUPS d,

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
432: where b.PAGE_ID = l_page_id