DBA Data[Home] [Help]

APPS.BSC_PERIODICITIES_PUB dependencies on BSC_KPIS_VL

Line 679: FROM BSC_KPIS_VL K

675: ,x_Msg_Data OUT NOCOPY VARCHAR2
676: ) IS
677: CURSOR c_Objectives IS
678: SELECT K.NAME
679: FROM BSC_KPIS_VL K
680: , BSC_KPI_PERIODICITIES P
681: WHERE P.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id
682: AND K.INDICATOR = P.INDICATOR;
683:

Line 1317: ,BSC_KPIS_VL K

1313:
1314: CURSOR C_Obj_List IS
1315: SELECT K.NAME, K.INDICATOR
1316: FROM BSc_KPI_PERIODICITIES P
1317: ,BSC_KPIS_VL K
1318: WHERE K.INDICATOR = P.INDICATOR
1319: AND K.PROTOTYPE_FLAG NOT IN (1, 2, 3)
1320: AND P.PERIODICITY_ID = p_Periodicity_Id;
1321: