APPS.QPR_DEAL_PVT dependencies on QPR_PRICE_PLANS_VL

Line 291: from qpr_price_plans_vl p, qpr_scopes s

287: l_datamart number;
288:
289: cursor c_datamart is
290: select distinct p.price_plan_id, s.scope_id , p.name, p.start_date
291: from qpr_price_plans_vl p, qpr_scopes s
292: where p.aw_created_flag = 'Y' and p.aw_status_code = 'PROCESS'
293: --and p.use_for_deal_flag = 'Y'
294: and p.aw_type_code = 'DATAMART'
295: and p.instance_id = p_instance_id

Line 419: FROM QPR_PRICE_PLANS_VL

415: l_tot_cost_meas := s_cube_code || '_QPR_T_COS';
416:
417:
418: SELECT aw_CODE, currency_code into awName, l_aw_curr
419: FROM QPR_PRICE_PLANS_VL
420: WHERE price_plan_id = p_price_plan_id
421: and rownum < 2;
422:
423: -- ATTACH AW