APPS.QPR_DELETE_AW dependencies on QPR_PRICE_PLANS_B

Line 35: FROM QPR_PRICE_PLANS_B

31:
32: begin
33: SELECT price_plan_id, aw_code
34: INTO l_price_plan_id, l_aw_name1
35: FROM QPR_PRICE_PLANS_B
36: WHERE PRICE_PLAN_ID =P_PRICE_PLAN_ID
37: and rownum < 2;
38: exception
39: when no_data_found then

Line 98: update qpr_price_plans_b

94: ' '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
95:
96: l_stmtnum := 70;
97:
98: update qpr_price_plans_b
99: set aw_created_flag = 'N'
100: where price_plan_id = p_price_plan_id;
101:
102: commit;

Line 185: delete from qpr_price_plans_b where price_plan_id = p_price_plan_id;

181:
182: l_table_name := 'PRICEPLANS';
183:
184: l_stmtnum := 170;
185: delete from qpr_price_plans_b where price_plan_id = p_price_plan_id;
186: delete from qpr_price_plans_tl where price_plan_id = p_price_plan_id;
187: l_stmtnum := 180;
188: delete from qpr_dimensions where price_plan_id = p_price_plan_id;
189: l_stmtnum := 190;