DBA Data[Home] [Help]

APPS.OPI_EDW_OPM_JOB_DETAIL_F_C dependencies on DUAL

Line 368: select OPI_EDW_JOB_DETAIL_INC_S.nextval into l_seq_id from dual;

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