APPS.QPR_TRANSFORMATION dependencies on QPR_MEASURE_DATA

Line 118: from qpr_measure_data csd, qpr_transf_rules_b qtr

114: qtr.LEVEL_VALUE_TO,
115: qtr.LIMIT_DIM_CODE,
116: qtr.LIMIT_DIM_LEVEL,
117: qtr.LIMIT_DIM_LEVEL_VALUE
118: from qpr_measure_data csd, qpr_transf_rules_b qtr
119: where csd.measure_type_code = p_from_dim_meas_code and
120: csd.instance_id=p_instance_id and
121: csd.time_level_value between p_from_date and p_to_date
122: and qtr.transf_header_id = p_transf_header_id and

Line 319: update qpr_measure_data

315: end;
316: end;
317: begin
318: if transf_header_rec.to_dim_code = 'DSB' then
319: update qpr_measure_data
320: set dsb_level_value = transf_header_rec.to_value,
321: measure7_number =
322: qpr_transformation.get_num(measure_rec.level_value_to),
323: measure8_number =

Line 330: update qpr_measure_data

326: last_updated_by = fnd_global.user_id,
327: last_update_login = fnd_global.login_id
328: where measure_value_id = measure_rec.measure_value_id;
329: elsif transf_header_rec.to_dim_code = 'VLB' then
330: update qpr_measure_data
331: set vlb_level_value = transf_header_rec.to_value,
332: measure11_number =
333: qpr_transformation.get_num(measure_rec.level_value_to),
334: measure12_number =

Line 343: update qpr_measure_data

339: last_updated_by = fnd_global.user_id,
340: last_update_login = fnd_global.login_id
341: where measure_value_id = measure_rec.measure_value_id;
342: elsif transf_header_rec.to_dim_code = 'MGB' then
343: update qpr_measure_data
344: set mgb_level_value = transf_header_rec.to_value,
345: measure18_number =
346: qpr_transformation.get_num(measure_rec.level_value_to),
347: measure19_number =