APPS.MSC_ATP_DB_UTILS dependencies on MSC_PLANS

Line 1597: FROM MSC_PLANS

1593: END IF;
1594:
1595: SELECT latest_refresh_number
1596: INTO l_current_refresh_number
1597: FROM MSC_PLANS
1598: WHERE plan_id = p_plan_id;
1599:
1600: IF PG_DEBUG in ('Y', 'C') THEN
1601: msc_sch_wb.atp_debug('Delete_Row: ' || 'l_current_refresh_number := ' || l_current_refresh_number);

Line 4865: FROM MSC_PLANS

4861: DELETE FROM msc_alloc_demands
4862: WHERE parent_demand_id = p_copy_demand_ids(i)
4863: AND plan_id = p_copy_plan_ids(i)
4864: AND refresh_number <= (SELECT nvl(latest_refresh_number,-1)
4865: FROM MSC_PLANS
4866: WHERE plan_id = p_copy_plan_ids(i));
4867:
4868: END IF;
4869:

Line 4881: FROM MSC_PLANS

4877: DELETE FROM msc_demands
4878: WHERE demand_id = p_copy_demand_ids(i)
4879: AND plan_id = p_copy_plan_ids(i)
4880: AND refresh_number <= (SELECT nvl(latest_refresh_number,-1)
4881: FROM MSC_PLANS
4882: WHERE plan_id = p_copy_plan_ids(i));
4883:
4884: END IF;
4885: END IF;