DBA Data[Home] [Help]

APPS.QPR_MAINTAIN_AW dependencies on QPR_CUBES

Line 476: from qpr_cubes a, qpr_measures b, qpr_measures c

472: cursor c_cube_meas is
473: select a.cube_code cube_code,
474: b.measure_ppa_code measure_ppa_code,
475: c.measure_id measure_id
476: from qpr_cubes a, qpr_measures b, qpr_measures c
477: where a.cube_id=b.cube_id and
478: b.price_plan_id=p_plan_id
479: and b.measure_ppa_code = c.measure_ppa_code
480: and c.price_plan_id = qpr_sr_util.g_datamart_tmpl_id

Line 517: from qpr_cubes a, qpr_measures b

513: end;
514:
515:
516: select count(*) into measure_count
517: from qpr_cubes a, qpr_measures b
518: where a.cube_id=b.cube_id and
519: b.price_plan_id=p_plan_id
520: and b.meas_type='INPUT';
521: