APPS.CN_COLLECT_CUSTOM SQL Statements

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

Line: 39

  SELECT OBJ.name
  INTO   package_name
  FROM   cn_table_map_objects tmov, cn_objects obj
  WHERE  tmov.table_map_id = p_table_map_id
  and obj.object_id = tmov.object_id
         AND tmov.tm_object_type = 'PKS'
         and tmov.org_id = obj.org_id
         AND tmov.org_id = x_org_id;