APPS.QPR_MAINTAIN_AW dependencies on QPR_PRICE_PLANS_B

Line 278: from qpr_price_plans_b

274: start_date, end_date
275: into p_sr_instance_id, g_base_uom,
276: g_currency_code,
277: l_start_date, l_end_date
278: from qpr_price_plans_b
279: where price_plan_id=p_price_plan_id
280: and aw_created_flag = 'Y';
281: exception
282: WHEN NO_DATA_FOUND THEN

Line 450: update qpr_price_plans_b

446: if p_clean_temp='Y' then
447: delete qpr_plan_measures
448: where run_number=g_run_number;
449: end if;
450: update qpr_price_plans_b
451: set aw_status_code = 'PROCESS'
452: where price_plan_id=p_price_plan_id;
453: commit;
454:

Line 509: from qpr_price_plans_b

505: begin
506:
507: begin
508: select aw_code into l_aw_name
509: from qpr_price_plans_b
510: where price_plan_id= p_plan_id;
511: exception
512: when others then null;
513: end;