APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_SUPPLIER_PLANS

Line 258: SELECT msc_supplier_plans_s.nextval

254: -- --------------------------
255: -- initialize query id
256: -- --------------------------
257: g_error_stmt := 'Debug - initialize - 10';
258: SELECT msc_supplier_plans_s.nextval
259: INTO g_query_id
260: FROM dual;
261:
262: -- --------------------------------------------------------

Line 505: INSERT INTO msc_supplier_plans(

501: bucket_cells(bkt+g_num_of_buckets*8);
502: END LOOP;
503:
504: FORALL bkt in 1..nvl(bkt_data.qty1.last,0)
505: INSERT INTO msc_supplier_plans(
506: query_id,
507: last_update_date,
508: last_updated_by,
509: creation_date,