APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_TAB_INDICATORS

Line 353: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));

349: AND a.relation_type=1
350: AND a.dim_level_id IN
351: (SELECT dim_level_id
352: FROM bsc_kpi_dim_level_properties WHERE indicator IN
353: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));
354:
355: CURSOR c_childs IS
356: SELECT a.dim_level_id child_dim_level_id
357: FROM bsc_sys_dim_level_rels a

Line 363: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));

359: AND a.relation_type=1
360: AND a.dim_level_id IN
361: (SELECT dim_level_id
362: FROM bsc_kpi_dim_level_properties WHERE indicator IN
363: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));
364:
365: CURSOR c_fil_view IS
366: SELECT level_view_name
367: FROM bsc_sys_filters_views

Line 376: FROM bsc_tab_indicators ti

372: CURSOR c_tab_kpis IS
373: SELECT DISTINCT kpi_measure_id, indicator
374: FROM bsc_kpi_analysis_measures_b
375: WHERE indicator IN (SELECT DISTINCT ti.indicator
376: FROM bsc_tab_indicators ti
377: WHERE ti.tab_id = p_tab_id);
378:
379: BEGIN
380:

Line 1388: FROM bsc_tab_indicators b

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
1391: FROM bsc_sys_dim_levels_b d
1392: WHERE d.dim_level_id = p_dim_level_id);

Line 1403: FROM bsc_tab_indicators WHERE tab_id = p_tab_id

1399: AND EXISTS ( SELECT indicator
1400: FROM bsc_kpi_dim_level_properties b
1401: WHERE b.dim_level_id = a.parent_dim_level_id
1402: AND indicator IN (SELECT indicator
1403: FROM bsc_tab_indicators WHERE tab_id = p_tab_id
1404: )
1405: );
1406:
1407: CURSOR c_childs IS

Line 1414: WHERE b.indicator IN (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id)

1410: WHERE a.parent_dim_level_id = p_dim_level_id
1411: AND a.relation_type=1
1412: AND EXISTS (SELECT b.dim_level_id
1413: FROM bsc_kpi_dim_level_properties b
1414: WHERE b.indicator IN (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id)
1415: and b.dim_level_id = a.dim_level_id );
1416:
1417: BEGIN
1418:

Line 1573: FROM bsc_tab_indicators WHERE tab_id = p_tab_id

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:
1576: CURSOR c_parents IS
1577: SELECT a.dim_level_id, a.parent_dim_level_id, a.relation_col

Line 1585: FROM bsc_tab_indicators WHERE tab_id = p_tab_id

1581: AND EXISTS ( SELECT indicator
1582: FROM bsc_kpi_dim_level_properties b
1583: WHERE b.dim_level_id = a.parent_dim_level_id
1584: AND indicator IN (SELECT indicator
1585: FROM bsc_tab_indicators WHERE tab_id = p_tab_id
1586: )
1587: );
1588:
1589: TYPE ref_cursor IS REF CURSOR;

Line 1786: FROM bsc_tab_indicators WHERE tab_id = p_tab_id

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:
1789: CURSOR c_childs IS
1790: SELECT a.dim_level_id child_dim_level_id,

Line 1798: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));

1794: AND a.relation_type=1
1795: AND a.dim_level_id IN
1796: (SELECT dim_level_id
1797: FROM bsc_kpi_dim_level_properties WHERE indicator IN
1798: (SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_tab_id));
1799:
1800: TYPE ref_cursor IS REF CURSOR;
1801: ref_cur ref_cursor;
1802: