DBA Data[Home] [Help]

APPS.BSC_BIS_WRAPPER_PVT dependencies on BSC_TAB_INDICATORS

Line 1759: bsc_tab_indicators tk

1755: m.indicator IN (
1756: SELECT
1757: tk.indicator
1758: FROM
1759: bsc_tab_indicators tk
1760: WHERE
1761: tk.tab_id = p_tab_id
1762: ) AND (
1763: m.indicator NOT IN (

Line 1788: ' FROM bsc_tab_indicators tk, bsc_user_kpi_access ka'||

1784: -- Populate BSC_BIS_MEASURES_DATA for the default analysis combination
1785: -- of each kpi which user has access and belongs to the given tab.
1786:
1787: l_sql := 'SELECT tk.indicator'||
1788: ' FROM bsc_tab_indicators tk, bsc_user_kpi_access ka'||
1789: ' WHERE tk.tab_id = :1 AND tk.indicator = ka.indicator AND ka.responsibility_id = :2';
1790:
1791: l_caching_sql := 'SELECT caching_key'||
1792: ' FROM bsc_bis_measures_data'||

Line 2810: ' FROM bsc_tab_indicators tk, bsc_user_kpi_access ka'||

2806: -- Populate BSC_BIS_MEASURES_DATA for the default analysis combination
2807: -- of each kpi which user has access and belongs to the given tab.
2808:
2809: l_sql := 'SELECT tk.indicator'||
2810: ' FROM bsc_tab_indicators tk, bsc_user_kpi_access ka'||
2811: ' WHERE tk.tab_id = :1 AND tk.indicator = ka.indicator AND ka.responsibility_id = :2';
2812:
2813: l_caching_sql := 'SELECT caching_key'||
2814: ' FROM bsc_bis_measures_data'||