APPS.BSC_KPI_SERIES_PUB dependencies on BSC_DB_DATASET_DIM_SETS_V

Line 844: bsc_db_dataset_dim_sets_v v

840: dim_set_id
841: INTO
842: l_DimSet_Id
843: FROM
844: bsc_db_dataset_dim_sets_v v
845: WHERE
846: v.indicator = p_indicator AND
847: v.A0 = p_Analysis_Option0 AND
848: v.A1 = p_Analysis_Option1 AND

Line 1515: bsc_db_dataset_dim_sets_v db,

1511: CURSOR c_dimset_dataset_map IS
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

Line 1527: bsc_db_dataset_dim_sets_v db,

1523: CURSOR c_AO_Comb IS
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

Line 1543: bsc_db_dataset_dim_sets_v db,

1539: CURSOR c_AO_Comb_Series IS
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

Line 1559: bsc_db_dataset_dim_sets_v

1555: CURSOR c_Dim_Set IS
1556: SELECT DISTINCT
1557: dim_set_id
1558: FROM
1559: bsc_db_dataset_dim_sets_v
1560: WHERE
1561: indicator = p_Indicator AND
1562: A0 = p_Analysis_Option0 AND
1563: A1 = p_Analysis_Option1 AND