DBA Data[Home] [Help]

APPS.OPI_EDW_OPMCOGS_F_C dependencies on DUAL

Line 398: select OPI_EDW_OPMCOGS_INC_S.nextval into l_seq_id from dual;

394: l_status VARCHAR2(30);
395: l_industry VARCHAR2(30);
396: BEGIN
397: p_count := 0;
398: select OPI_EDW_OPMCOGS_INC_S.nextval into l_seq_id from dual;
399: IF p_view_id = 1 THEN
400: INSERT /*+ parallel(OPI_EDW_OPMCOGS_INC) */
401: into OPI_EDW_OPMCOGS_INC (LINE_ID,view_id,seq_id)
402: SELECT