DBA Data[Home] [Help]

APPS.QPR_CREATE_AW dependencies on QPR_CUBES

Line 11: from qpr_measures b , qpr_cubes c

7: o_meas varchar2(100);
8: begin
9: SELECT c.cube_code||'_'||b.measure_ppa_code
10: into o_meas
11: from qpr_measures b , qpr_cubes c
12: where b.price_plan_id = p_price_plan_id
13: and b.measure_ppa_code = p_term_code
14: and c.cube_id=b.cube_id;
15: return o_meas;

Line 26: qpr_cubes b, qpr_dimensions c

22:
23: CURSOR qprmodels_cur IS
24: SELECT a1.model_id, a1.model_name, c.dim_code dim_code
25: FROM qpr_models a1, qpr_cube_dims a,
26: qpr_cubes b, qpr_dimensions c
27: WHERE a.price_plan_id = p_price_plan_id
28: AND b.cube_id = a.cube_id
29: AND b.cube_ppa_code = p_cube_code
30: -- AND c.dim_code = a.dim_code