eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_CALCULATIONS_PUB dependencies on BSC_SYS_DATASETS_B

Line 637: l_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;

633: FUNCTION is_balance_measure(
634: p_kpi_measure_id IN NUMBER
635: ) RETURN VARCHAR2
636: IS
637: l_dataset_id bsc_sys_datasets_b.dataset_id%TYPE;
638: BEGIN
639: IF p_kpi_measure_id IS NOT NULL THEN
640: SELECT dataset_id
641: INTO

Line 670: WHERE measure_id IN (SELECT measure_id1 FROM bsc_sys_datasets_b

666: IS
667:
668: CURSOR c_data_set IS
669: SELECT measure_col FROM bsc_sys_measures
670: WHERE measure_id IN (SELECT measure_id1 FROM bsc_sys_datasets_b
671: WHERE dataset_id = p_dataset_id
672: UNION
673: SELECT measure_id2 FROM bsc_sys_datasets_b
674: WHERE dataset_id = p_dataset_id);

Line 673: SELECT measure_id2 FROM bsc_sys_datasets_b

669: SELECT measure_col FROM bsc_sys_measures
670: WHERE measure_id IN (SELECT measure_id1 FROM bsc_sys_datasets_b
671: WHERE dataset_id = p_dataset_id
672: UNION
673: SELECT measure_id2 FROM bsc_sys_datasets_b
674: WHERE dataset_id = p_dataset_id);
675:
676: CURSOR c_db_measure_cols (p_measure_col VARCHAR2) IS
677: SELECT measure_type