APPS.OEONUM SQL Statements

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

Line: 37

	SELECT 'X' into dummy FROM ALL_SEQUENCES
               WHERE SEQUENCE_NAME = sequence_name and rownum=1;

Line: 68

                SELECT      'X'
                INTO DUMMY
                FROM        ALL_SOURCE
                WHERE       NAME='AD_DDL'
                AND         ROWNUM = 1 ;

Line: 98

            SELECT      'X'
                INTO DUMMY
                FROM        USER_SOURCE
                WHERE       NAME='OEXOENUM'
                AND         ROWNUM = 1 ;

Line: 193

    SELECT RELEASE_NAME INTO Rel_name FROM FND_PRODUCT_GROUPS
	WHERE ROWNUM = 1;

Line: 265

       sql_buffer :=  'SELECT '  || sequence_name ||
              '.NEXTVAL '                 ||
               ' FROM SYS.DUAL';

Line: 331

	SELECT LAST_NUMBER into sequence_number FROM ALL_SEQUENCES
               WHERE SEQUENCE_NAME = l_sequence_name and rownum=1;