APPS.BSC_UPDATE_CALC dependencies on BSC_KPI_DATA_TABLES

Line 14: -- If a table is used directly by an indicator, this table is in BSC_KPI_DATA_TABLES

10: ) RETURN BOOLEAN IS
11:
12: e_unexpected_error EXCEPTION;
13:
14: -- If a table is used directly by an indicator, this table is in BSC_KPI_DATA_TABLES
15: -- Additionally, a table is used by an indicator if it is connected to an indicator table
16: -- by calculation type = 5 (Merge targets)
17: -- We need to filter target tables.
18: TYPE t_cursor IS REF CURSOR;

Line 22: ' FROM bsc_kpi_data_tables'||

18: TYPE t_cursor IS REF CURSOR;
19:
20: /* c_indicator t_cursor;
21: c_indicator_sql VARCHAR2(2000) := 'SELECT indicator, dim_set_id'||
22: ' FROM bsc_kpi_data_tables'||
23: ' WHERE table_name = :1 OR'||
24: ' table_name = ('||
25: ' SELECT DISTINCT table_name'||
26: ' FROM bsc_db_calculations'||

Line 31: FROM bsc_kpi_data_tables

27: ' WHERE parameter1 = :2 AND'||
28: ' calculation_type = :3)'; */
29: cursor c_indicator( pTableName varchar2, pParam1 varchar2,pCalcType number) is
30: SELECT indicator, dim_set_id
31: FROM bsc_kpi_data_tables
32: WHERE table_name = pTableName
33: OR table_name = (
34: SELECT DISTINCT table_name
35: FROM bsc_db_calculations

Line 1654: FROM bsc_db_calculations c, bsc_kpi_data_tables kt, bsc_kpi_data_tables ktp

1650: h_key_zero_code bsc_db_calculations.parameter1%TYPE;
1651:
1652: cursor c_keys_needing_zero_code(pTableName varchar2) is
1653: SELECT DISTINCT c.parameter1
1654: FROM bsc_db_calculations c, bsc_kpi_data_tables kt, bsc_kpi_data_tables ktp
1655: WHERE c.table_name = kt.table_name AND
1656: c.calculation_type = 4 AND
1657: kt.indicator = ktp.indicator AND
1658: kt.dim_set_id = ktp.dim_set_id AND

Line 1682: FROM bsc_kpi_data_tables

1678: h_lst_expressions VARCHAR2(32700);
1679:
1680: CURSOR c_pt_name (p_sum_table VARCHAR2) IS
1681: SELECT DISTINCT projection_data
1682: FROM bsc_kpi_data_tables
1683: WHERE table_name = p_sum_table;
1684:
1685: h_ref_table VARCHAR2(30);
1686: