APPS.BSC_UPDATE_UTIL dependencies on BSC_KPI_MEASURE_PROPS

Line 6404: FROM bsc_kpi_measure_props

6400: RETURN NUMBER IS
6401:
6402: CURSOR c_color_by_total(p_indicator NUMBER, p_kpi_measure_id NUMBER) IS
6403: SELECT color_by_total
6404: FROM bsc_kpi_measure_props
6405: WHERE indicator = p_indicator
6406: AND kpi_measure_id = p_kpi_measure_id;
6407:
6408: l_color_by_total bsc_kpi_measure_props.color_by_total%TYPE;

Line 6408: l_color_by_total bsc_kpi_measure_props.color_by_total%TYPE;

6404: FROM bsc_kpi_measure_props
6405: WHERE indicator = p_indicator
6406: AND kpi_measure_id = p_kpi_measure_id;
6407:
6408: l_color_by_total bsc_kpi_measure_props.color_by_total%TYPE;
6409:
6410: BEGIN
6411:
6412: l_color_by_total := 1;

Line 6445: FROM bsc_kpi_measure_props

6441: RETURN NUMBER IS
6442:
6443: CURSOR c_ytd_flag(p_indicator NUMBER, p_kpi_measure NUMBER) IS
6444: SELECT COUNT(default_calculation) ytd_flag
6445: FROM bsc_kpi_measure_props
6446: WHERE default_calculation = 2
6447: AND kpi_measure_id = p_kpi_measure
6448: AND indicator = p_indicator;
6449:

Line 6487: FROM bsc_kpi_measure_props

6483: RETURN NUMBER IS
6484:
6485: CURSOR c_apply_color_flag(p_indicator NUMBER, p_kpi_measure_id NUMBER) IS
6486: SELECT apply_color_flag
6487: FROM bsc_kpi_measure_props
6488: WHERE indicator = p_indicator
6489: AND kpi_measure_id = p_kpi_measure_id;
6490:
6491: l_apply_color_flag bsc_kpi_measure_props.apply_color_flag%TYPE;

Line 6491: l_apply_color_flag bsc_kpi_measure_props.apply_color_flag%TYPE;

6487: FROM bsc_kpi_measure_props
6488: WHERE indicator = p_indicator
6489: AND kpi_measure_id = p_kpi_measure_id;
6490:
6491: l_apply_color_flag bsc_kpi_measure_props.apply_color_flag%TYPE;
6492:
6493: BEGIN
6494:
6495: l_apply_color_flag := 0;