APPS.ORACLENAVIGATE dependencies on ICX_PAGES

Line 684: icx_pages b

680: begin
681: select display_name
682: into l_name
683: from icx_page_plugs a,
684: icx_pages b
685: where b.user_id = icx_sec.g_user_id
686: and b.page_id = a.page_id
687: and a.page_id = l_page_id
688: and a.responsibility_id = -1

Line 727: ICX_PAGES b

723: begin
724: select DISPLAY_NAME
725: into l_name
726: from ICX_PAGE_PLUGS a,
727: ICX_PAGES b
728: where b.USER_ID = icx_sec.g_user_id
729: and b.PAGE_ID = a.PAGE_ID
730: and a.RESPONSIBILITY_ID = -1
731: and a.MENU_ID = -1

Line 733: from ICX_PAGES

729: and b.PAGE_ID = a.PAGE_ID
730: and a.RESPONSIBILITY_ID = -1
731: and a.MENU_ID = -1
732: and b.page_id in (select MIN(page_id)
733: from ICX_PAGES
734: where user_id = icx_sec.g_user_id
735: and PAGE_TYPE = 'USER');
736: exception
737: when no_data_found then

Line 760: from ICX_PAGES

756: and ipp.entry_sequence = fme.entry_sequence
757: and fff.function_id = fme.function_id
758: and fff.function_name = 'ICX_NAVIGATE_PLUG'
759: and ipp.page_id in (select MIN(page_id)
760: from ICX_PAGES
761: where user_id = icx_sec.g_user_id
762: and PAGE_TYPE = 'USER');
763: exception
764: when no_data_found then