APPS.BSC_IM_UTILS dependencies on BSC_KPI_DATA_TABLES

Line 39: from bsc_kpi_data_tables data

35: select count(1)from bsc_db_calculations calc
36: where calc.calculation_type = 4
37: and calc.table_name =
38: (select table_name
39: from bsc_kpi_data_tables data
40: where
41: data.indicator = p_kpi
42: and data.mv_name = p_mv_name
43: and rownum=1)

Line 77: select projection_data from bsc_kpi_data_tables

73: connect by source_table_name = prior table_name
74: start with source_table_name = p_b_pt_table_name;
75: --------------------------------------------
76: cursor cSTableNameForPT(p_kpi number) is
77: select projection_data from bsc_kpi_data_tables
78: where indicator = p_kpi
79: and projection_data = p_b_pt_table_name;
80: --------------------------------------------
81: cursor cZeroCode(p_sTable IN VARCHAR2) is