[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;