DBA Data[Home] [Help]

APPS.BSC_METADATA_DESC dependencies on BSC_LOOKUPS

Line 402: FROM BSC_LOOKUPS B

398: -------------------------------------
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;