DBA Data[Home] [Help]

APPS.BSC_BIS_WRAPPER_PVT dependencies on BSC_USER_KPI_ACCESS

Line 1767: bsc_user_kpi_access a

1763: m.indicator NOT IN (
1764: SELECT
1765: a.indicator
1766: FROM
1767: bsc_user_kpi_access a
1768: WHERE
1769: a.responsibility_id = p_responsibility_id
1770: ) OR
1771: m.indicator = (

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'||

Line 2853: bsc_user_kpi_access a

2849: m.indicator NOT IN (
2850: SELECT
2851: a.indicator
2852: FROM
2853: bsc_user_kpi_access a
2854: WHERE
2855: a.responsibility_id = p_responsibility_id
2856: ) OR
2857: m.indicator = (