DBA Data[Home] [Help]

APPS.CCT_CHECK_SEQ_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

     	  v_seq_stmt:='SELECT '||cct_schema||'.'||sequence_name||'.NEXTVAL from dual';
Line: 74

     	 v_max_stmt:='SELECT max('||column_name||') from '||cct_schema||'.'||table_name;
Line: 115

             EXECUTE IMMEDIATE 'select ' || cct_schema||'.'||sequence_name || '.nextval from dual where rownum=1 ' INTO l_num;