22: c_get_meas_data SYS_REFCURSOR;
23: t_meas_data num_type;
24:
25: begin
26: date_from := fnd_date.canonical_to_date(p_from_date);
27: date_to := fnd_date.canonical_to_date(p_to_date);
28:
29: l_sql := '';
30: l_sql := 'select measure_value_id from qpr_measure_data ';
23: t_meas_data num_type;
24:
25: begin
26: date_from := fnd_date.canonical_to_date(p_from_date);
27: date_to := fnd_date.canonical_to_date(p_to_date);
28:
29: l_sql := '';
30: l_sql := 'select measure_value_id from qpr_measure_data ';
31: l_sql := l_sql || ' where instance_id = :1 and measure_type_code = :2 ';