APPS.BSC_COLOR_RANGES_PUB dependencies on BSC_KPIS_B

Line 61: FROM bsc_kpis_b

57: l_user_id FND_USER.user_id%TYPE;
58:
59: CURSOR c_shared_obj IS
60: SELECT indicator
61: FROM bsc_kpis_b
62: WHERE source_indicator = p_objective_id
63: AND share_flag = 2 -- shared objective.
64: AND prototype_flag <> 2;
65: BEGIN

Line 183: FROM bsc_kpis_b

179: l_objective_id NUMBER;
180:
181: CURSOR c_shared_obj IS
182: SELECT indicator
183: FROM bsc_kpis_b
184: WHERE source_indicator = p_objective_id
185: AND share_flag = 2 -- shared objective.
186: AND prototype_flag <> 2;
187:

Line 852: FROM bsc_kpis_b

848: AND NVL(property_value, -1) = DECODE(p_property_value, NULL, -1, p_property_value);
849:
850: CURSOR c_shared_obj IS
851: SELECT indicator
852: FROM bsc_kpis_b
853: WHERE source_indicator = p_objective_id
854: AND share_flag = 2 -- shared objective.
855: AND prototype_flag <> 2;
856: BEGIN

Line 1242: FROM bsc_kpis_b

1238: l_an_opt2 NUMBER;
1239: l_series_id NUMBER;
1240: CURSOR c_shared_obj IS
1241: SELECT indicator
1242: FROM bsc_kpis_b
1243: WHERE source_indicator = p_objective_id
1244: AND share_flag = 2 -- shared objective.
1245: AND prototype_flag <> 2;
1246:

Line 1387: FROM bsc_kpis_b

1383: l_series_id NUMBER;
1384:
1385: CURSOR c_shared_obj IS
1386: SELECT indicator
1387: FROM bsc_kpis_b
1388: WHERE source_indicator = l_objective_id
1389: AND share_flag = 2 -- shared objective.
1390: AND prototype_flag <> 2;
1391:

Line 1494: FROM bsc_kpis_b

1490: BEGIN
1491: IF (p_kpi_measure_id IS NULL) THEN
1492: SELECT weighted_color_method
1493: INTO l_color_method
1494: FROM bsc_kpis_b
1495: WHERE indicator = p_objective_id;
1496: ELSE
1497: SELECT color_method
1498: INTO l_color_method