177: l_property_code bsc_sys_init.property_code%TYPE ;
178: l_property_value bsc_sys_init.property_value%TYPE ;
179: l_tab_id NUMBER;
180: l_tab_view_id NUMBER;
181: l_name bsc_tab_views_vl.name%TYPE;
182: l_help bsc_tab_views_vl.help%TYPE;
183: l_function_id NUMBER;
184:
185: CURSOR c_all_tab_views IS
178: l_property_value bsc_sys_init.property_value%TYPE ;
179: l_tab_id NUMBER;
180: l_tab_view_id NUMBER;
181: l_name bsc_tab_views_vl.name%TYPE;
182: l_help bsc_tab_views_vl.help%TYPE;
183: l_function_id NUMBER;
184:
185: CURSOR c_all_tab_views IS
186: SELECT tab_id, tab_view_id, name, help
183: l_function_id NUMBER;
184:
185: CURSOR c_all_tab_views IS
186: SELECT tab_id, tab_view_id, name, help
187: FROM bsc_tab_views_vl v
188: WHERE v.tab_view_id > 1;
189:
190: BEGIN
191: l_property_code := 'TAB_VIEW_FUNCS';