APPS.BSC_UPDATE_INC dependencies on BSC_KPIS_VL

Line 627: ' FROM bsc_kpis_vl k, bsc_kpi_data_tables t'||

623: -- Insert into the local array h_tables the system tables used
624: -- by the indicators with prototype flag = 6
625:
626: h_sql := 'SELECT DISTINCT t.table_name'||
627: ' FROM bsc_kpis_vl k, bsc_kpi_data_tables t'||
628: ' WHERE k.indicator = t.indicator AND'||
629: ' k.prototype_flag = :1 AND t.table_name IS NOT NULL';
630:
631: --BSC-BIS-DIMENSIONS: If Loader is running in KPI_MODE only consider indicators

Line 687: FROM bsc_kpis_vl;

683: TYPE t_cursor IS REF CURSOR;
684:
685: cursor c_All_Indicators is
686: SELECT indicator
687: FROM bsc_kpis_vl;
688:
689: h_indicator NUMBER;
690:
691: BEGIN

Line 746: FROM bsc_kpis_vl

742: TYPE t_cursor IS REF CURSOR;
743:
744: cursor c_indicators(pCalId number) is
745: SELECT indicator
746: FROM bsc_kpis_vl
747: WHERE calendar_id = pCalId ;
748:
749: h_indicator NUMBER;
750: