APPS.BSC_METADATA_DESC dependencies on BSC_KPI_CALCULATIONS

Line 403: ,BSC_KPI_CALCULATIONS A

399: CURSOR c_KPI_Calculations IS
400: SELECT A.CALCULATION_ID, B.MEANING AS NAME
401: ,A.USER_LEVEL0, A.USER_LEVEL1, A.DEFAULT_VALUE
402: FROM BSC_LOOKUPS B
403: ,BSC_KPI_CALCULATIONS A
404: WHERE B.LOOKUP_TYPE = 'BSC_CALCULATION'
405: AND A.INDICATOR = l_Kpi_Id
406: AND NVL(TO_NUMBER(B.LOOKUP_CODE), A.CALCULATION_ID ) = A.CALCULATION_ID;
407: -------------------------------------

Line 706: l_not_found_msg := ' There is not any Calculations Metadata defined in table BSC_KPI_CALCULATIONS';

702: put_line(l_not_found_msg);
703: END IF;
704:
705: --- kpi Calculations ------------------------------------------------------------
706: l_not_found_msg := ' There is not any Calculations Metadata defined in table BSC_KPI_CALCULATIONS';
707: put_line('---------------------------------------------------------------------------');
708: put_line('Objective ID <'||l_Kpi_Id||'> Calculations Definition: ');
709: put_line('---------------------------------------------------------------------------');
710: FOR bsc_cd IN c_KPI_Calculations LOOP