APPS.MSC_HP_UTIL dependencies on MSC_RES_PLAN_UPDATES

Line 260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);

256: delete from msc_hp_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
257: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
258: commit;
259:
260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);
262: commit;
263:
264: delete from msc_hp_row_dtls where plan_id=p_plan_id;

Line 261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);

257: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
258: commit;
259:
260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);
262: commit;
263:
264: delete from msc_hp_row_dtls where plan_id=p_plan_id;
265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);