APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_DB_MEASURE_COLS_VL

Line 1560: FROM bsc_db_measure_cols_vl

1556: SELECT measure_group_id
1557: , projection_id
1558: , measure_type
1559: , help
1560: FROM bsc_db_measure_cols_vl
1561: WHERE measure_col = c_measure_col_name;
1562:
1563: CURSOR c_Bsc_Measure_Color_Formula IS
1564: SELECT s_Color_Formula

Line 3644: , bsc_db_measure_cols_vl db

3640: CURSOR c_Meas_Grp IS
3641: SELECT measure_group_id
3642: FROM bsc_sys_datasets_vl d
3643: , bsc_sys_measures m
3644: , bsc_db_measure_cols_vl db
3645: WHERE d.dataset_id = p_dataset_id
3646: AND m.measure_id = d.measure_id1
3647: AND m.measure_col =db.measure_col;
3648:

Line 3656: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c

3652:
3653: if bsc_utility.isBscInProductionMode then
3654: select count(c.projection_id)
3655: into l_count
3656: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c
3657: where m.measure_id = d.measure_id1
3658: and c.measure_col = m.measure_col
3659: and d.dataset_id = p_dataset_id;
3660:

Line 3667: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c

3663:
3664: if(l_count <> 0) then
3665: select c.projection_id, c.measure_type
3666: into l_proj_id, l_measure_type
3667: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c
3668: where m.measure_id = d.measure_id1
3669: and c.measure_col = m.measure_col
3670: and d.dataset_id = p_dataset_id;
3671: end if;