DBA Data[Home] [Help]

APPS.MSC_UPDATE_RESOURCE dependencies on MSC_PROCESS_EFFECTIVITY

Line 2080: from msc_process_effectivity mpe,

2076: p_effective_date out nocopy date,
2077: p_disable_date out nocopy date) IS
2078: CURSOR eff_c IS
2079: select mpe.effectivity_date, mpe.disable_date
2080: from msc_process_effectivity mpe,
2081: msc_supplies ms
2082: where ms.plan_id = p_plan_id
2083: and ms.transaction_id = p_supply_id
2084: and mpe.plan_id = ms.plan_id