APPS.BSC_METADATA_DESC dependencies on BSC_TAB_INDICATORS

Line 301: FROM BSC_TAB_INDICATORS TI

297: WHERE Source_Indicator = l_Kpi_Id;
298: -------------------------------------
299: CURSOR c_Tab_Ids IS
300: SELECT TI.TAB_ID, T.NAME
301: FROM BSC_TAB_INDICATORS TI
302: ,BSC_TABS_VL T
303: WHERE TI.INDICATOR = l_Kpi_Id
304: AND T.TAB_ID (+) = TI.TAB_ID;
305: -------------------------------------

Line 311: (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR = l_Kpi_Id));

307: SELECT IND_GROUP_ID, NAME, TAB_ID
308: FROM BSC_TAB_IND_GROUPS_VL
309: WHERE IND_GROUP_ID = l_kpi_group_id
310: AND ( TAB_ID = -1 OR TAB_ID IN
311: (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR = l_Kpi_Id));
312: -------------------------------------
313: CURSOR c_KPI_Responsibilities IS
314: SELECT K.RESPONSIBILITY_ID, R.RESPONSIBILITY_NAME
315: FROM BSC_USER_KPI_ACCESS K,

Line 476: put_line('Scorecard Information from BSC_TAB_INDICATORS and BSC_TABS_VL table');

472: END IF;
473:
474: l_not_found_msg := ' Objective <'||l_Kpi_Id||'> is not associated to any Scorecard ';
475: put_line('---------------------------------------------------------------------------');
476: put_line('Scorecard Information from BSC_TAB_INDICATORS and BSC_TABS_VL table');
477: put_line('---------------------------------------------------------------------------');
478: FOR bsc_cd IN c_Tab_Ids LOOP
479: l_not_found_msg := NULL;
480: put_line('-> TAB_ID (Scorecard Id) is <'||bsc_cd.TAB_ID||'>');