APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on BSC_KPI_DIM_LEVEL_PROPERTIES

Line 352: FROM bsc_kpi_dim_level_properties WHERE indicator IN

348: WHERE a.dim_level_id = p_dim_level_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

Line 362: FROM bsc_kpi_dim_level_properties WHERE indicator IN

358: WHERE a.parent_dim_level_id = p_dim_level_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

Line 1400: FROM bsc_kpi_dim_level_properties b

1396: FROM bsc_sys_dim_level_rels a
1397: WHERE a.dim_level_id = p_dim_level_id
1398: AND a.relation_type=1
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: )

Line 1413: FROM bsc_kpi_dim_level_properties b

1409: FROM bsc_sys_dim_level_rels a
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

Line 1582: FROM bsc_kpi_dim_level_properties b

1578: FROM bsc_sys_dim_level_rels a
1579: WHERE a.dim_level_id = p_parent_level_id
1580: AND a.relation_type=1
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: )

Line 1797: FROM bsc_kpi_dim_level_properties WHERE indicator IN

1793: WHERE a.parent_dim_level_id = p_dim_level_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;