APPS.MSC_X_NETTING3_PKG dependencies on MSC_PLANS

Line 1858: l_plan_order_at_risk msc_plans.compile_designator%type;

1854: l_cp_org_id Number;
1855: l_cp_customer_id Number;
1856: l_cp_customer_site_id Number;
1857: l_cp_item_id Number;
1858: l_plan_order_at_risk msc_plans.compile_designator%type;
1859: l_plan_order_at_risk_id number;
1860: l_demand_id Number;
1861: l_item_id Number;
1862:

Line 2192: from msc_plans

2188: --dbms_output.put_line('Plan order at risk ' || l_plan_order_at_risk);
2189: BEGIN
2190: select plan_id
2191: into l_plan_order_at_risk_id
2192: from msc_plans
2193: where compile_designator = l_plan_order_at_risk;
2194: EXCEPTION
2195: when others then
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The plan for order at risk has not defined as a profile option ');