DBA Data[Home] [Help]

APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_SUPPLIES

Line 2197: FROM msc_supplies sup

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
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;

Line 2206: from msc_supplies

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); */
2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: NULL;