DBA Data[Home] [Help]

APPS.RG_REPORT_SETS_PKG SQL Statements

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

Line: 12

        SELECT rg_report_sets_s.nextval
        INTO   new_sequence_number
        FROM   dual;
Line: 27

     SELECT count(*)
     INTO   rec_returned
     FROM   rg_report_sets
     WHERE  report_set_id <> cur_report_set_id
     AND    name = new_name
     AND    application_id = cur_application_id;