APPS.MSC_ATP_DB_UTILS dependencies on MSC_PLANS

Line 1444: FROM MSC_PLANS

1440: END IF;
1441:
1442: SELECT latest_refresh_number
1443: INTO l_current_refresh_number
1444: FROM MSC_PLANS
1445: WHERE plan_id = p_plan_id;
1446:
1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: msc_sch_wb.atp_debug('Delete_Row: ' || 'l_current_refresh_number := ' || l_current_refresh_number);

Line 4683: FROM MSC_PLANS

4679: DELETE FROM msc_alloc_demands
4680: WHERE parent_demand_id = p_copy_demand_ids(i)
4681: AND plan_id = p_copy_plan_ids(i)
4682: AND refresh_number <= (SELECT nvl(latest_refresh_number,-1)
4683: FROM MSC_PLANS
4684: WHERE plan_id = p_copy_plan_ids(i));
4685:
4686: END IF;
4687:

Line 4699: FROM MSC_PLANS

4695: DELETE FROM msc_demands
4696: WHERE demand_id = p_copy_demand_ids(i)
4697: AND plan_id = p_copy_plan_ids(i)
4698: AND refresh_number <= (SELECT nvl(latest_refresh_number,-1)
4699: FROM MSC_PLANS
4700: WHERE plan_id = p_copy_plan_ids(i));
4701:
4702: END IF;
4703: END IF;