APPS.QPR_DELETE_AW dependencies on QPR_USR_PRICE_PLANS

Line 64: from qpr_usr_price_plans

60: end;
61:
62: begin
63: select 1 into l_rownum
64: from qpr_usr_price_plans
65: where aw_type_code = 'DATAMART'
66: and price_plan_id = p_price_plan_id
67: and default_assg_flag = 'Y'
68: and rownum < 2;

Line 170: delete from qpr_usr_price_plans where price_plan_id = p_price_plan_id;

166: l_stmtnum := 140;
167:
168: l_table_name := 'ASSIGNMENTS';
169:
170: delete from qpr_usr_price_plans where price_plan_id = p_price_plan_id;
171:
172: fnd_file.put_line(fnd_file.log,'deleted assignment for analytic workspace'
173: ||l_aw_name1||' '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
174: