DBA Data[Home] [Help]

APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_SUPPLIES

Line 2082: FROM msc_supplies sup

2078: BEGIN
2079: DELETE FROM msc_user_notes mun
2080: WHERE mun.plan_id = p_plan_id
2081: AND NOT exists (SELECT 1 -- sup.plan_id,sup.transaction_id
2082: FROM msc_supplies sup
2083: WHERE plan_id = mun.plan_id
2084: AND sup.sr_instance_id = mun.sr_instance_id
2085: AND sup.transaction_id = mun.transaction_id);
2086:

Line 2090: from msc_supplies

2086:
2087: /*delete from msc_user_notes
2088: where plan_id = p_plan_id and
2089: (plan_id,transaction_id) not in (select plan_id,transaction_id
2090: from msc_supplies
2091: where plan_id = p_plan_id); */
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: NULL;