DBA Data[Home] [Help]

APPS.MSC_UPDATE_RESOURCE dependencies on MSC_PROCESS_EFFECTIVITY

Line 1802: from msc_process_effectivity mpe,

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