306: return 'N';
307: end if;
308:
309: l_mtl_sales_ord_id :=
310: qa_results_interface_pkg.OEHeader_to_MTLSales
311: ( x_so_header_id );
312:
313: open om_plans_cur (l_mtl_sales_ord_id);
314: fetch om_plans_cur into plan_applicable;
347: -- bug 11831190
348: -- Deriving the sales_order_id based on the header_id
349: --
350: l_mtl_sales_ord_id :=
351: qa_results_interface_pkg.OEHeader_to_MTLSales
352: ( x_so_header_id );
353:
354: open om_plans_cur(l_mtl_sales_ord_id);
355: fetch om_plans_cur into plan_applicable;