APPS.BSC_UPDATE dependencies on BSC_KPIS_VL

Line 1079: FROM bsc_kpis_vl

1075: h_table_name VARCHAR2(50);
1076:
1077: CURSOR c_indicators (p_calendar_id NUMBER) IS
1078: SELECT indicator
1079: FROM bsc_kpis_vl
1080: WHERE calendar_id = p_calendar_id;
1081:
1082: h_indicator NUMBER;
1083:

Line 1647: ' FROM bsc_kpis_vl'||

1643:
1644: /*
1645: c_prototype t_cursor;
1646: c_prototype_sql VARCHAR2(2000) := 'SELECT COUNT(prototype_flag)'||
1647: ' FROM bsc_kpis_vl'||
1648: ' WHERE prototype_flag IN (1, 2, 3, 4, 5)';
1649: */
1650:
1651: h_count NUMBER;

Line 1665: FROM bsc_kpis_vl

1661: CLOSE c_prototype;
1662: */
1663: SELECT COUNT(prototype_flag)
1664: INTO h_count
1665: FROM bsc_kpis_vl
1666: WHERE prototype_flag IN (1, 2, 3, 4, 5);
1667:
1668: IF h_count > 0 THEN
1669: h_res := TRUE;

Line 4758: FROM bsc_kpis_vl

4754: h_prototype_flag NUMBER;
4755:
4756: CURSOR c_indicator (p_kpi NUMBER) IS
4757: SELECT prototype_flag, name
4758: FROM bsc_kpis_vl
4759: WHERE indicator = p_kpi;
4760:
4761: BEGIN
4762: h_num_indicators := 0;

Line 5880: bsc_kpis_vl);

5876: WHERE p.indicator IN (
5877: SELECT
5878: indicator
5879: FROM
5880: bsc_kpis_vl);
5881:
5882:
5883: RETURN TRUE;
5884:

Line 6354: ' from bsc_kpis_vl'||

6350: BSC_APPS.Add_Value_Big_In_Cond(1, g_indicators(h_i));
6351: END LOOP;
6352:
6353: h_sql := 'select indicator, name'||
6354: ' from bsc_kpis_vl'||
6355: ' where prototype_flag NOT IN (:1, :2, :3) and '||h_where_cond;
6356: h_i := 0;
6357: OPEN h_cursor FOR h_sql USING 0, 6, 7;
6358: LOOP

Line 6378: ' from bsc_kpis_vl'||

6374: BSC_APPS.Add_Value_Big_In_Cond(1, x_system_tables(h_i));
6375: END LOOP;
6376:
6377: h_sql := 'select indicator, name'||
6378: ' from bsc_kpis_vl'||
6379: ' where prototype_flag NOT IN (:1, :2, :3) and'||
6380: ' indicator in (select indicator'||
6381: ' from bsc_kpi_data_tables'||
6382: ' where '||h_where_cond||