1798: p_effective_date out nocopy date,
1799: p_disable_date out nocopy date) IS
1800: CURSOR eff_c IS
1801: select mpe.effectivity_date, mpe.disable_date
1802: from msc_process_effectivity mpe,
1803: msc_supplies ms
1804: where ms.plan_id = p_plan_id
1805: and ms.transaction_id = p_supply_id
1806: and mpe.plan_id = ms.plan_id