APPS.BSC_KPI_SERIES_PUB dependencies on BSC_SYS_DATASETS_VL

Line 35: l_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';

31: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
32: l_A0_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
33: l_A1_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
34: l_A2_Def bsc_kpi_analysis_measures_b.analysis_option0%TYPE;
35: l_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';
36:
37: CURSOR c_kpi_measure_id IS
38: SELECT
39: km.kpi_measure_id

Line 60: bsc_sys_datasets_vl

56: CURSOR c_Source IS
57: SELECT
58: source
59: FROM
60: bsc_sys_datasets_vl
61: WHERE
62: dataset_id = p_Dataset_Id;
63:
64: BEGIN

Line 789: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;

785: ) IS
786: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
787: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
788: l_Count NUMBER := 0;
789: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;
790: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := 0;
791: l_Option_Name bsc_kpi_analysis_options_vl.name%TYPE;
792: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
793:

Line 1516: bsc_sys_datasets_vl ds

1512: SELECT
1513: db.dim_set_id, db.dataset_id, count(1)
1514: FROM
1515: bsc_db_dataset_dim_sets_v db,
1516: bsc_sys_datasets_vl ds
1517: WHERE
1518: ds.source = 'BSC' AND
1519: db.indicator = p_indicator AND db.dataset_id = ds.dataset_id
1520: GROUP BY db.dim_set_id, db.dataset_id

Line 1528: bsc_sys_datasets_vl ds

1524: SELECT
1525: db.dim_set_id, db.dataset_id, count(1)
1526: FROM
1527: bsc_db_dataset_dim_sets_v db,
1528: bsc_sys_datasets_vl ds
1529: WHERE
1530: ds.source = 'BSC' AND
1531: db.indicator = p_indicator AND
1532: db.dataset_id = ds.dataset_id AND

Line 1544: bsc_sys_datasets_vl ds

1540: SELECT
1541: db.dim_set_id, db.dataset_id
1542: FROM
1543: bsc_db_dataset_dim_sets_v db,
1544: bsc_sys_datasets_vl ds
1545: WHERE
1546: ds.source = 'BSC' AND
1547: db.indicator = p_indicator AND
1548: db.dataset_id = ds.dataset_id AND