DBA Data[Home] [Help]

APPS.BSC_DATASETS_PVT dependencies on BIS_INDICATORS

Line 1507: l_short_name bis_indicators.short_name%TYPE;

1503: from bsc_kpi_analysis_measures_vl am, bsc_kpis_vl k
1504: where am.indicator = k.indicator
1505: and dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1506:
1507: l_short_name bis_indicators.short_name%TYPE;
1508: CURSOR c_short_name(l_dataset_id NUMBER)
1509: IS
1510: SELECT
1511: short_name

Line 1513: bis_indicators

1509: IS
1510: SELECT
1511: short_name
1512: FROM
1513: bis_indicators
1514: WHERE dataset_id = l_dataset_id;
1515:
1516: l_indicators varchar2(32000);
1517:

Line 1893: -- mdamle 04/23/2003 - PMD - Measure Definer - short_name not used, instead dataset_id added to bis_indicators

1889:
1890: l_count number;
1891:
1892: begin
1893: -- mdamle 04/23/2003 - PMD - Measure Definer - short_name not used, instead dataset_id added to bis_indicators
1894: select count(1)
1895: into l_count
1896: -- from BSC_SYS_MEASURES
1897: from bis_indicators i, bsc_sys_datasets_vl d

Line 1897: from bis_indicators i, bsc_sys_datasets_vl d

1893: -- mdamle 04/23/2003 - PMD - Measure Definer - short_name not used, instead dataset_id added to bis_indicators
1894: select count(1)
1895: into l_count
1896: -- from BSC_SYS_MEASURES
1897: from bis_indicators i, bsc_sys_datasets_vl d
1898: where short_name = p_Measure_Name
1899: and i.dataset_id = d.dataset_id;
1900:
1901: return l_count;