APPS.CNREDF_TABLES_PKG SQL Statements

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

Line: 17

      SELECT cn_objects_s.nextval
	INTO X_table_id
	FROM dual;

Line: 34

  PROCEDURE select_columns (X_table_level	IN OUT		varchar2,
			    X_table_level_name 	IN OUT		varchar2) IS

  BEGIN

    SELECT meaning
      INTO X_table_level_name
      FROM cn_lookups
     WHERE lookup_code = X_table_level
       AND lookup_type = 'TABLE_LEVEL';

Line: 45

  END select_columns;