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_COLOR_CALC_UTIL dependencies on BSC_COLOR_TYPE_PROPS

Line 38: FROM bsc_color_type_props

34:
35: -- For P & L Objective threshold.
36: CURSOR c_pl_color IS
37: SELECT color_range_id
38: FROM bsc_color_type_props
39: WHERE indicator = p_indicator
40: --AND kpi_measure_id = p_kpi_measure_id;
41: AND property_value = 1;
42: -- For kpi_measure threshold.

Line 45: FROM bsc_color_type_props

41: AND property_value = 1;
42: -- For kpi_measure threshold.
43: CURSOR c_kpi_measure_color IS
44: SELECT color_range_id
45: FROM bsc_color_type_props
46: WHERE indicator = p_indicator
47: AND kpi_measure_id = p_kpi_measure_id;
48:
49: -- For weight Objective threshold.

Line 52: FROM bsc_color_type_props

48:
49: -- For weight Objective threshold.
50: CURSOR c_objective_color IS
51: SELECT color_range_id
52: FROM bsc_color_type_props
53: WHERE indicator = p_indicator
54: AND kpi_measure_id IS NULL;
55:
56: CURSOR c_threshold_values IS