DBA Data[Home] [Help]

APPS.BSC_PERIODICITIES_PUB dependencies on BSC_KPI_PERIODICITIES

Line 680: , BSC_KPI_PERIODICITIES P

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:
684:

Line 858: FROM BSC_KPI_PERIODICITIES P

854: -- You cannot delete a periodicity, if it being used in some
855: -- objectives.
856:
857: SELECT COUNT(1) INTO l_Count
858: FROM BSC_KPI_PERIODICITIES P
859: WHERE P.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_id;
860:
861: IF (l_Count <> 0) THEN
862: FOR cObj IN c_Objectives LOOP

Line 1316: FROM BSc_KPI_PERIODICITIES P

1312: l_Msg_Data VARCHAR2(2000);
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;