APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_USER_NOTES

Line 2194: DELETE FROM msc_user_notes mun

2190:
2191: Procedure purge_user_notes_data(p_plan_id number)
2192: IS
2193: BEGIN
2194: DELETE FROM msc_user_notes mun
2195: WHERE mun.plan_id = p_plan_id
2196: AND NOT exists (SELECT 1 -- sup.plan_id,sup.transaction_id
2197: FROM msc_supplies sup
2198: WHERE plan_id = mun.plan_id

Line 2203: /*delete from msc_user_notes

2199: AND sup.sr_instance_id = mun.sr_instance_id
2200: AND sup.transaction_id = mun.transaction_id)
2201: AND MUN.transaction_id is not null;
2202:
2203: /*delete from msc_user_notes
2204: where plan_id = p_plan_id and
2205: (plan_id,transaction_id) not in (select plan_id,transaction_id
2206: from msc_supplies
2207: where plan_id = p_plan_id); */