APPS.BSC_METADATA_DESC dependencies on BSC_TAB_IND_GROUPS_VL

Line 308: FROM BSC_TAB_IND_GROUPS_VL

304: AND T.TAB_ID (+) = TI.TAB_ID;
305: -------------------------------------
306: CURSOR c_KPI_Group IS
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: -------------------------------------

Line 490: l_not_found_msg := 'ERROR. Objective Id <'||l_Kpi_Id||'> is assigned to a not existing Objective Group ID (IND_GROUP_ID)in table BSC_KPIS_B. Objective Group Id does not exist in BSC_TAB_IND_GROUPS_VL ';

486: IF (l_not_found_msg IS NOT NULL) THEN
487: put_line(l_not_found_msg);
488: END IF;
489:
490: l_not_found_msg := 'ERROR. Objective Id <'||l_Kpi_Id||'> is assigned to a not existing Objective Group ID (IND_GROUP_ID)in table BSC_KPIS_B. Objective Group Id does not exist in BSC_TAB_IND_GROUPS_VL ';
491: put_line('---------------------------------------------------------------------------');
492: put_line('Objective Group Information from BSC_TAB_IND_GROUPS_VL table:');
493: put_line('---------------------------------------------------------------------------');
494: FOR bsc_cd IN c_KPI_Group LOOP

Line 492: put_line('Objective Group Information from BSC_TAB_IND_GROUPS_VL table:');

488: END IF;
489:
490: l_not_found_msg := 'ERROR. Objective Id <'||l_Kpi_Id||'> is assigned to a not existing Objective Group ID (IND_GROUP_ID)in table BSC_KPIS_B. Objective Group Id does not exist in BSC_TAB_IND_GROUPS_VL ';
491: put_line('---------------------------------------------------------------------------');
492: put_line('Objective Group Information from BSC_TAB_IND_GROUPS_VL table:');
493: put_line('---------------------------------------------------------------------------');
494: FOR bsc_cd IN c_KPI_Group LOOP
495: l_not_found_msg := NULL;
496: put_line('-> IND_GROUP_ID (Objective Group ID) is <'||bsc_cd.IND_GROUP_ID||'>');