364: l_status VARCHAR2(30);
365: l_industry VARCHAR2(30);
366: BEGIN
367: p_count := 0;
368: select OPI_EDW_JOB_DETAIL_INC_S.nextval into l_seq_id from dual;
369: /* insert into Incremental table all line_id but not part of missing currency convenrsion rows */
370: INSERT /*+ parallel(OPI_EDW_OPM_JOB_DETAIL_INC) */
371: into OPI_EDW_OPM_JOB_DETAIL_INC(PRIMARY_KEY,view_id,seq_id)
372: SELECT