DBA Data[Home] [Help]

APPS.ORACLEMYPAGE dependencies on FND_USER_RESP_GROUPS

Line 66: FND_USER_RESP_GROUPS d,

62: b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
63: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
64: c.DESCRIPTION,a.WEB_HTML_CALL
65: from fnd_responsibility e,
66: FND_USER_RESP_GROUPS d,
67: FND_FORM_FUNCTIONS a,
68: FND_MENU_ENTRIES_VL c,
69: ICX_PAGE_PLUGS b
70: where b.PAGE_ID = l_page_id

Line 102: FND_USER_RESP_GROUPS d,

98: b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
99: b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
100: c.DESCRIPTION,a.WEB_HTML_CALL
101: from fnd_responsibility e,
102: FND_USER_RESP_GROUPS d,
103: FND_FORM_FUNCTIONS a,
104: FND_MENU_ENTRIES_VL c,
105: ICX_PAGE_PLUGS b
106: where b.PAGE_ID = l_page_id

Line 313: from fnd_responsibility fr, FND_USER_RESP_GROUPS furg,

309: cursor plugInfo (p_page_id number, p_user_id number) is
310: select fff.FUNCTION_NAME, fff.TYPE, fff.WEB_HOST_NAME,
311: fff.WEB_HTML_CALL, fff.FUNCTION_ID, ipp.PLUG_ID,
312: nvl(ipp.DISPLAY_NAME,fme.PROMPT) display, ipp.DISPLAY_SEQUENCE
313: from fnd_responsibility fr, FND_USER_RESP_GROUPS furg,
314: fnd_form_functions fff, fnd_menu_entries_vl fme,
315: icx_page_plugs ipp
316: where ipp.PAGE_ID = p_page_id and fme.MENU_ID = ipp.MENU_ID
317: and fme.ENTRY_SEQUENCE = ipp.ENTRY_SEQUENCE

Line 697: FND_USER_RESP_GROUPS b,

693: fsg.security_group_key,
694: fa.application_short_name
695: from FND_SECURITY_GROUPS_VL fsg,
696: fnd_responsibility_vl a,
697: FND_USER_RESP_GROUPS b,
698: FND_APPLICATION fa
699: where b.user_id = icx_sec.g_user_id
700: and b.start_date <= sysdate
701: and (b.end_date is null or b.end_date > sysdate)

Line 726: FND_USER_RESP_GROUPS b,

722: fsg.security_group_key,
723: fa.application_short_name
724: from FND_SECURITY_GROUPS_VL fsg,
725: fnd_responsibility_vl a,
726: FND_USER_RESP_GROUPS b,
727: FND_APPLICATION fa
728: where b.user_id = icx_sec.g_user_id
729: and b.start_date <= sysdate
730: and (b.end_date is null or b.end_date > sysdate)

Line 882: FND_USER_RESP_GROUPS b

878: -- 1584711 nlbarlow remove order by
879: select count(*) INTO l_resps_count
880: from FND_SECURITY_GROUPS_VL fsg,
881: FND_RESPONSIBILITY_VL a,
882: FND_USER_RESP_GROUPS b
883: where b.user_id = l_user_id
884: and b.start_date <= sysdate
885: and (b.end_date is null or b.end_date > sysdate)
886: and b.RESPONSIBILITY_id = a.responsibility_id

Line 911: FND_USER_RESP_GROUPS b

907: end if;
908: select a.version INTO l_resp_type
909: from FND_SECURITY_GROUPS_VL fsg,
910: FND_RESPONSIBILITY_VL a,
911: FND_USER_RESP_GROUPS b
912: where b.user_id = l_user_id
913: and b.start_date <= sysdate
914: and (b.end_date is null or b.end_date > sysdate)
915: and b.RESPONSIBILITY_id = a.responsibility_id