APPS.BIS_SETUP_KPI_PKG dependencies on BIS_OBJ_PROPERTIES

Line 64: FROM bis_obj_properties prop, fnd_form_functions_vl page_funcs, fnd_menus menus

60: pages.page_name, pages.page_internal_name
61: FROM
62: (SELECT page_funcs.user_function_name page_name,
63: prop.object_name page_internal_name, menus.menu_id page_menu_id
64: FROM bis_obj_properties prop, fnd_form_functions_vl page_funcs, fnd_menus menus
65: WHERE prop.object_type = 'PAGE'
66: --AND prop.object_name like '%_OA'
67: AND page_funcs.type = 'JSP'
68: AND UPPER(page_funcs.web_html_call) like 'OA.JSP?AKREGIONCODE=BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'

Line 170: bis_obj_properties b

166: CURSOR c_pages_and_impl_flag(p_c_kpi_id NUMBER) IS
167: SELECT distinct b.IMPLEMENTATION_FLAG, a.page_name
168: --FROM TABLE(cast(getKpisAndPages AS t_bis_kpi_page_tab)) a,
169: FROM bis_setup_kpi_page a,
170: bis_obj_properties b
171: WHERE a.indicator_id = p_c_kpi_id
172: AND a.page_internal_name = b.object_name
173: AND b.object_type = 'PAGE';
174: