DBA Data[Home] [Help]

APPS.CNSYTC_COLUMNS_PKG SQL Statements

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

Line: 17

      SELECT name
        INTO x_dimension_name
        FROM cn_dimensions
       WHERE dimension_id = x_dimension_id ;
Line: 38

      SELECT cn_objects_s.nextval
        INTO x_object_id
        FROM sys.dual ;
Line: 58

      SELECT count(name)
        INTO x_count
        FROM cn_obj_tables_v
       WHERE name = x_name
         AND schema = x_schema ;
Line: 81

      SELECT count(name)
        INTO x_count
        FROM cn_obj_columns_v
       WHERE name = x_name
         AND table_id = x_table_id ;