APPS.BSC_METADATA_DESC dependencies on BSC_KPI_PROPERTIES

Line 410: FROM BSC_KPI_PROPERTIES

406: AND NVL(TO_NUMBER(B.LOOKUP_CODE), A.CALCULATION_ID ) = A.CALCULATION_ID;
407: -------------------------------------
408: CURSOR c_KPI_Properties IS
409: SELECT PROPERTY_CODE, PROPERTY_VALUE, SECONDARY_VALUE
410: FROM BSC_KPI_PROPERTIES
411: WHERE INDICATOR = l_Kpi_Id;
412: -------------------------------------
413: CURSOR c_KPI_Data_Tables IS
414: SELECT PERIODICITY_ID, DIM_SET_ID, LEVEL_COMB

Line 722: l_not_found_msg := ' There is not any KPI Properties defined in table BSC_KPI_PROPERTIES';

718: put_line(l_not_found_msg);
719: END IF;
720:
721: --- kpi Properties -------------------------------------------------------
722: l_not_found_msg := ' There is not any KPI Properties defined in table BSC_KPI_PROPERTIES';
723: put_line('---------------------------------------------------------------------------');
724: put_line('Objective ID <'||l_Kpi_Id||'> Properties from table BSC_KPI_PROPERTIES ');
725: put_line('---------------------------------------------------------------------------');
726: FOR bsc_cd IN c_KPI_Properties LOOP

Line 724: put_line('Objective ID <'||l_Kpi_Id||'> Properties from table BSC_KPI_PROPERTIES ');

720:
721: --- kpi Properties -------------------------------------------------------
722: l_not_found_msg := ' There is not any KPI Properties defined in table BSC_KPI_PROPERTIES';
723: put_line('---------------------------------------------------------------------------');
724: put_line('Objective ID <'||l_Kpi_Id||'> Properties from table BSC_KPI_PROPERTIES ');
725: put_line('---------------------------------------------------------------------------');
726: FOR bsc_cd IN c_KPI_Properties LOOP
727: l_not_found_msg := NULL;
728: put_line('-> PROPERTY_CODE is <'||bsc_cd.PROPERTY_CODE||'>' );