APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_KPI_DIM_LEVELS_VL

Line 1386: FROM bsc_kpi_dim_levels_vl a

1382: CURSOR c_key_items IS
1383: SELECT a.default_key_value,
1384: a.level_shortname,
1385: a.level_view_name
1386: FROM bsc_kpi_dim_levels_vl a
1387: WHERE a.indicator IN (SELECT b.indicator
1388: FROM bsc_tab_indicators b
1389: WHERE b.tab_id = p_tab_id)
1390: AND a.level_shortname IN ( SELECT d.short_name

Line 1571: FROM bsc_kpi_dim_levels_vl

1567: SELECT * FROM bsc_sys_dim_levels_vl WHERE dim_level_id = cp_dim_level_id;
1568:
1569: CURSOR c_kpi_dim_level_details(cp_level_shortname VARCHAR2) IS
1570: SELECT *
1571: FROM bsc_kpi_dim_levels_vl
1572: WHERE level_shortname = cp_level_shortname AND indicator IN (SELECT indicator
1573: FROM bsc_tab_indicators WHERE tab_id = p_tab_id
1574: );
1575:

Line 1784: FROM bsc_kpi_dim_levels_vl

1780: SELECT short_name FROM bsc_sys_dim_levels_vl WHERE dim_level_id = cp_dim_level_id;
1781:
1782: CURSOR c_kpi_dim_level_details(cp_level_shortname VARCHAR2) IS
1783: SELECT *
1784: FROM bsc_kpi_dim_levels_vl
1785: WHERE level_shortname = cp_level_shortname AND indicator IN (SELECT indicator
1786: FROM bsc_tab_indicators WHERE tab_id = p_tab_id
1787: );
1788: