APPS.QPR_CREATE_AW SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

   SELECT  c.cube_code||'_'||b.measure_ppa_code
   into o_meas
   from qpr_measures b , qpr_cubes c
   where  b.price_plan_id = p_price_plan_id
   and b.measure_ppa_code = p_term_code
   and c.cube_id=b.cube_id;

Line: 24

   SELECT a1.model_id, a1.model_name, c.dim_code dim_code
   FROM qpr_models a1, qpr_cube_dims a,
  	qpr_cubes b,  qpr_dimensions c
WHERE a.price_plan_id = p_price_plan_id
 AND b.cube_id = a.cube_id
 AND b.cube_ppa_code = p_cube_code
-- AND c.dim_code = a.dim_code
 and c.price_plan_dim_id = a.price_plan_dim_id
  and a1.model_meas_dim_code = c.dim_ppa_code;

Line: 36

   SELECT model_id,execution_sequence,lhs_expression_id,rhs_expression_id,operator
   from qpr_model_equations
   where model_id = modelId
   order by execution_sequence;

Line: 42

   SELECT expression_id,sequence,term_id
   from qpr_expressions
   where expression_id = exprId
   order by sequence;

Line: 49

   SELECT term_id,term_code,term_type
   from qpr_terms
   where term_id = termId;

Line: 86

 dbms_aw.EXECUTE('update;commit;');

Line: 160

SELECT AW_XML,AW_CODE
INTO L_CLB,L_AW_NAME1
FROM QPR_PRICE_PLANS_B
WHERE PRICE_PLAN_ID = P_PRICE_PLAN_ID;

Line: 175

DBMS_AW.AW_UPDATE('APPS',L_AW_NAME1);

Line: 181

UPDATE QPR_PRICE_PLANS_B
SET AW_CREATED_FLAG = 'Y'
WHERE PRICE_PLAN_ID = P_PRICE_PLAN_ID;